IQuery.ParamsCheck

Syntax

ParamsCheck: Boolean;

Description

The ParamsCheck property determines whether parameters are considered at query execution.

Comments

If the property is set to True, values of parameters are considered at query execution.

Example

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Query: IQuery;

Params: IMetabaseObjectParams;

ParamsVal: IMetabaseObjectParamValues;

Dat: 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";

Dat:=MObj.Open(ParamsVal) As IDatasetInstance;

End Sub Main;

After executing the example, for query with the Query_1 identifier ignoring of parameters of query is set. The query is executed without set parameters.