EntityDAC

TCustomContext.ExecuteSQL Method

Execute a SQL statement directly in the database.

Class

TCustomContext

Syntax

procedure ExecuteSQL(const SQL: string; Params: TEDParams = nil); overload;

Parameters
SQL
Specifies the SQL statement to be executed.
Params
Specifies the collection of the statement parameters.

Remarks

Call the ExecuteSQL method to execute a SQL statement directly in the database. Supply the Params collection with the parameters accordingly to the ones in the SQL statement which itself is passed in the SQL string parameter. The Params array must contain all IN and OUT parameters defined in the SQL statement. For OUT parameters provide any values of valid types so that they are explicitly defined before call to the method.

© 1997-2017 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback