Executes the given non-resultset query/statement and returns the number of affected records.

Syntax

Smartsite SXML CopyCode image Copy Code
integer sql.executenonquery(string sql)
integer sql.executenonquery(string sql, any[ ] parameters)

Parameters

Name Data Type Description
sql String SQL statement.
parameters Any[ ] Parameters for the specified sql statement.

Return Value

Data Type Description
Integer Number of records affected by the specified statement.

Expand image Example

SXML