EPUB | CHM | PDF

TPSQLDirectQuery.Properties.SQL

Top Previous Next

Contains the text of the SQL statement to execute for the query.

Syntax:

property SQL : TStrings;

Description:

Use SQL to provide the SQL statement that a component executes when its Open() method is called or Active property is set to True. At design time the SQL property can be edited by invoking the String List editor in the Object Inspector.

The SQL property may contain only one complete SQL statement at a time. In general, multiple "batch" statements are not allowed unless a particular server supports them.

Use TPSQLBatchExecute component if you want execute several queries in "batch" mode.

See also: Active property, Open() method, TPSQLBatchExecute component