This method is used internally to build the query to send to the server.
Don't use this method when using this component.
Overridden in child classes as:
- IBStoredProc::buildQuery()
Overrides
CustomIBTable::buildQuery() (This method is used internally to build the query to send to the server.)
Sends a query to the server for optimization prior to execution.
Call Prepare to have a remote database server allocate resources for the query and to perform additional optimizations.
If the query will only be executed once, the application does not need to explicitly call Prepare. Executing an unprepared query generates these calls automatically. However, if the same query is to be executed repeatedly, it is more efficient to prevent these automatic calls by calling Prepare explicitly.
Note: When you change the text of a query at runtime, the query is automatically closed and unprepared.
Overridden in child classes as:
- IBStoredProc::prepare()
Contains the parameters for a query’s SQL statement.
Access Params at runtime to view and set parameter names and values dynamically (at design time use the editor for the Params property to set parameter information). Index specifies the array element to access.
Contains the text of the SQL statement to execute for the query.
Use SQL to provide the SQL statement that a query component executes when its 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.