NoOfRows and NoOfFields

These functions return the number of rows and fields of a previously loaded table, respectively. 

The following example shows the use of these functions:

MyData:
Load
WeekDay,
RecNo() AS RecNo,
RowNo() As RowNo
Inline [
WeekDay
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
]
where WeekDay <> 'Tuesday';

LET vNoOfRows = NoOfRows('MyData');
LET vNoOfFields = NoOfFields('MyData');

TRACE NoOfRows() returns 6;
TRACE ;
TRACE NoOfFields() returns 3;

Exit Script;
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.119.117.207