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;