Data.Win.ADODB.TADOQuery.ParamCheck

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property ParamCheck: Boolean read GetParamCheck write SetParamCheck default 1;

C++

__property ParamCheck = {default=1};

Properties

Type Visibility Source Unit Parent
property published
Data.Win.ADODB.pas
Data.Win.ADODB.hpp
Data.Win.ADODB TADOQuery

Description

Specifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime.

Data.Win.ADODB.TADOQuery.ParamCheck inherits from Data.Win.ADODB.TCustomADODataSet.ParamCheck. All content below this line refers to Data.Win.ADODB.TCustomADODataSet.ParamCheck.

Specifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime.

Set ParamCheck to specify whether or not the Parameters property is initialized using ":Param" style parameters in an SQL statement specified in the CommandText property. If the SQL statement in CommandText only contains "?" style parameters, the Parameters property will only be initialized if the OLE DB provider returns parameter information for an SQL command. Otherwise, the parameters must be explicitly created using the CreateParameter method (TParameter).

When ParamCheck is true, a parameter is generated for each ":Param" style parameter in the SQL statement.

The default value of ParamCheck is true.

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 ADO dataset component. 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 ADO dataset component executing the DDL statement.

See Also