SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder


TSQLMemQuery.SQL
TSQLMemQuery
Top 

Contains the text of the SQL statement(s) to execute for the query.

property SQL: TStrings;

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

The SQL property may either one complete SQL statement or multiple "batch" statements separated by semicolon.

The SQL property can be used to access
The allowable syntax is a subset of SQL-92. See the SQLMemTable Developer's Guide help file for information on supported syntax.

The SQL statement in the SQL property may contain replaceable parameters, following standard SQL-92 syntax conventions. Parameters are created and stored in the Params property.


© AidAim Software SQLMemTable: