Method SqlStatement():execute() Foundation

Executes SQL statements with no return value.

Syntax
METHOD :execute() -> nRows
Return

This method returns the number of rows affected by an INSERT, UPDATE or DELETE SQL command. For all other SQL commands, 0 is returned.

Description

The method :execute() executes INSERT, UPDATE or DELETE SQL statements or other SQL statements that return nothing, such as a SQL DDL statement.

Use ";" to separate multiple SQL statements in your statement string.

Feedback

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.