Show: Delphi
C++
Display Preferences
API:Bde.DBTables.TQuery Declared Members
From XE2 API Documentation
Constructors & Destructors
| Create | Creates an instance of a query component. |
| Destroy | Destroys the instance of a query. |
Functions
| CreateHandle | |
| DefineProperties | |
| Disconnect | |
| ExecSQL | Executes the SQL statement for the query. |
| FreeStatement | |
| GetDataSource | |
| GetDetailLinkFields | Fills lists with the master and detail fields of the link. |
| GetParamsCount | |
| GetStatementHandle | |
| ParamByName | Accesses parameter information based on a specified parameter name. |
| Prepare | Sends a query to the Borland Database Engine (BDE) and the server for optimization prior to execution. |
| PSExecute | |
| PSGetCommandText | |
| PSGetCommandType | |
| PSGetDefaultOrder | |
| PSGetParams | |
| PSGetTableName | |
| PSSetCommandText | |
| PSSetParams | |
| SetDBFlag | |
| UnPrepare | Frees the resources allocated for a previously prepared query. |
Properties
| Constrained | Indicates whether updates and inserts that don't conform to the result set generated by a SELECT statement are permitted for Paradox and dBASE tables |
| Constraints | |
| DataLink | |
| DataSource | Specifies the data source component from which to extract current field values to use with same-name parameters in the query's SQL statement. |
| Local | Indicates whether a query references one or more Paradox or dBASE tables rather than SQL tables on a remote server. |
| ParamCheck | Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime. |
| ParamCount | Indicates the current number of parameters for the query. |
| Params | Contains the parameters for a query's SQL statement. |
| Prepared | Determines whether or not a query is prepared for execution. |
| RequestLive | Requests an updatable query result set from the database. |
| RowsAffected | Returns the number of rows operated upon by the latest query execution. |
| SQL | Contains the text of the SQL statement to execute for the query. |
| SQLBinary | Points to the binary data stream that represents an SQL query statement or result set. |
| StmtHandle | |
| Text | Points to the actual text of the SQL query passed to the Borland Database Engine (BDE). |
| UniDirectional | Determines whether or not Borland Database Engine (BDE) bidirectional cursors are enabled for a query's result set. |
| UpdateMode | |
| UpdateObject |