RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TSQLConnection.ExecuteDirect Method
TSQLConnection Class | TSQLConnection Members | SqlExpr Namespace | Description | See Also
Collapse All

Executes an SQL command that does not include parameters.

Pascal
function ExecuteDirect(const SQL: UnicodeString): Integer;
C++
__fastcall int ExecuteDirect(const UnicodeString SQL);
Description

Call ExecuteDirect to execute a single parameterless command on the server without the overhead of using an SQL dataset or preparing the statement before it executes. If the statement ordinarily returns a cursor, ExecuteDirect executes the statement, but does not return a cursor. 

SQL is the command to execute. 

ExecuteDirect returns the number of rows that were affected by the execution of the SQL query.

Note: To execute an SQL statement that includes parameters or that returns a cursor, use the Execute method instead.
 

 

See Also
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!