Db > Db Assembly Interfaces > IQuery > IQuery.ParamsCheck
ParamsCheck: Boolean;
The ParamsCheck property determines whether parameters are considered at query execution.
If the property is set to True, values of parameters are considered at query execution.
Sub UserProc;
Var
MB: IMetabase;
MObj: IMetabaseObject;
Query: IQuery;
Params: IMetabaseObjectParams;
ParamsVal: IMetabaseObjectParamValues;
DInst: IDatasetInstance;
Begin
MB := MetabaseClass.Active;
MObj := Mb.ItemById("Query_1").Edit;
Query := MObj As IQuery;
Query.ParamsCheck := False;
MObj.Save;
Params := MObj.Params;
ParamsVal := Params.CreateEmptyValues;
ParamsVal.Item(0).Value := "10";
DInst := MObj.Open(ParamsVal) As IDatasetInstance;
//...
// Work with query data
//...
DInst.Close;
End Sub UserProc;
After executing the example, ignoring of parameters of query is set for the query with the Query_1 identifier. The query is executed without set parameters.
See also:
