Bde.DBTables.TQuery.ParamCheck
Delphi
property ParamCheck: Boolean read FParamCheck write FParamCheck default True;
C++
__property bool ParamCheck = {read=FParamCheck, write=FParamCheck, default=1};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | Bde.DBTables.pas Bde.DBTables.hpp |
Bde.DBTables | TQuery |
Description
Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
Set ParamCheck to specify whether or not the Params property is cleared and regenerated if an application modifies the query's SQL property at runtime. By default ParamCheck is true, meaning that the Params property is automatically regenerated at runtime. When ParamCheck is true, the proper number of parameters is guaranteed to be generated for the current SQL statement.
This property is useful for data definition language (DDL) statements that contain parameters as part of the DDL statement and that are not parameters for the TQuery. For example, the DDL statement to create a stored procedure may contain parameter statements that are part of the stored procedure. Set ParamCheck to false to prevent these parameters from being mistaken for parameters of the TQuery executing the DDL statement.
An application that does not use parameterized queries may choose to set ParamCheck to false, but otherwise ParamCheck should be true.