Icon ExecSQL Method

procedure ExecSQL


Call the ExecSQL method to execute the SQL statement currently assigned to the SQL property. Use the ExecSQL method to execute any type of SQL statement, including scripts comprised of multiple SQL statements. If the SQL statement is a SELECT SQL statement or it ends with a SELECT SQL statement (such as with scripts), then the ExecSQL method will automatically call the Open method to open the query result set returned by the SELECT statement.

The ExecSQL method prepares the SQL statement or statements in the SQL property for execution if they have not already been prepared. To speed performance in situations where an SQL statement will be executed multiple times with parameters, an application should ordinarily call the Prepare method before calling the ExecSQL method for the first time.