Icon ExecSQL Method

procedure ExecSQL

Usage

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. If the SQL statement is a SELECT statement, 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 in the SQL property for execution if it has 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.
Image