IMetabaseObjectParamValue.Value

Executing the example requires that repository contains a query with the Query_1 identifier. This query is created with two parameters.

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    Params: IMetabaseObjectParamValues;
    Inst: IDatasetInstance;
    Fields: IDatasetInstanceFields;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("Query_1").Bind;
    Params := MObj.ParamValues;
    Params.Item(0).Value := 100;
    Params.Item(1).Value := 300;
    Inst := MObj.Open(Params) As IDatasetInstance;
    Fields := Inst.Fields;
    While Not Inst.Eof Do
        Debug.WriteLine(Fields.Item(0).Value);
        Inst.Next;
    End While;
End Sub UserProc;

After executing the example the query with the specified values of parameters is opened. Values of the first data column obtained on execution of the query are displayed in the development environment console.

IMetabaseObjectParamValue.Value

Syntax

Description

Example