<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : OZ e-Form Extension > OZ e-Form JavaScript API > Input > TextBox > Method >   GetDataSetCNT

 

 

Gets the number of dataset rows.

 

 

 

Prototype :

 

double GetDataSetCNT

(

       [ string DataSetPath ],

       [ string DistinctFieldName ],

       [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

If dataset path is omitted or set to null or "", the dataset path of the band will be applied by default.

 

Refer to GetDataSetSUM function for DistinctFieldName and ConditionFieldName.

 

When execute the function in a data band having group header/footer bands, group header/footer band, and a TextBox added to data sub-band, if the function use the dataset field of the band, the return value will may be different according to each band. To learn more, refer to description of GetDataSetCNT of each band.

 

 

 

Example :

 

//ODI name : Sample, dataset name : Orders

  _TraceLn(This.GetDataSetCNT("Sample.Orders"));

 

//ODI name can be omitted

  _TraceLn(This.GetDataSetCNT("Orders"));

 

//Dataset path can be omitted or set to null or ""

  _TraceLn(This.GetDataSetCNT());

  _TraceLn(This.GetDataSetCNT(null));

  _TraceLn(This.GetDataSetCNT(""));;

 

//specify DistinctFieldName

  _TraceLn(This.GetDataSetCNT("", "Region"));

 

//specify ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "", "Flag"));

 

//specify DistinctFieldName and ConditionFieldName

  _TraceLn(This.GetDataSetCNT("", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind,  OnStartBind

 

 

 

See also :

 

GetDataSetSUM