by nageswaragunupudi » Tue Feb 26, 2019 9:41 am
You may use the method GetRows(). This method has been there since the beginning,
aData := oRs:GetRows()
This method is further enhanced in 18.07:
method GetRows( [anRecs], [nStartPos], [aFields], [lWithRecNum] )
--> Returns array containing values of the records (default all
records) meeting the filter condition, if any, in the sorted order.
Parameter: lWithRecNum (last parameter) If .t., RecNo() is added to
each row as the column.
Call to this method does not change the record position.
oRs:GetRows( [lWithRecNum] ) --> All filtered records in sorted order.
oRs:GetRows( nRecs, [lWithRecNum] ) --> First nRecs (filtered in sorted
order)
oRs:GetRows( nRecs, nStartPos, [lWithRecNum] ) -->
nRecs starting from nStartPos
oRs:GetRows( aRecs, [lWithRecNum] ), where aRecs is an array of record
numbers. Records with the recnos contained in aRecs, whether or not
meeting filter condition in the same order of the array aRecs.
If a recno does not exist, blank record is included.
3rd Parameter: aFields ( array of field numbers / field names / expressions
containing field names ). If specified, returned array contains the
values of the fields specified
Regards
G. N. Rao.
Hyderabad, India