fox pro query to return sequential row number

Question

Is there any function like ROW_NUMBER() of sql server to return the sequential number of a row in visual fox pro?Actually i am using oledb command in c# to retrieve data from fox pro. I need something like row_number() function to select few rows at a time(like paging concept)

Answer 1

According to the MSDN Library, the ROW_NUMBER function returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

Visual FoxPro has a RECNO function that returns the current record number in the current or specified table. Review the MSDN Library for more information.