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 contain only one complete SQL statement at a time. In general, multiple "batch" statements are not allowed unless a particular server supports them. 

The SQL property can be used to access 

Paradox or dBASE tables, using local SQL. The allowable syntax is a subset of SQL-92. See the local SQL help file for information on supported syntax.  

Databases on the Local InterBase Server, using standard SQL-92 and specific InterBase extensions to SQL syntax. For information on syntax and limitations, see the InterBase Language Reference and online help. 

Databases on remote database servers using the appropriate SQL Links driver or ODBC (not available in all versions). Any standard statement in the server's SQL dialect is allowed. For information on SQL syntax and limitations, see the server documentation. 

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.

Add 

Clear 

Close 

ExecSQL 

LoadFromFile 

Open 

ParamByName 

Prepare 

Using Datasets with Decision Support Components 

Using TQuery 

Executing the Commands using TSQLDataSet 

Specifying the Data to Display using TSQLDataSet 

Using TQuery 

Using TSQLQuery