ADS record number in SQL query

[rdonnay]

I was sure that I wrote a program that returned the record number from an ADS SQL SELECT statement.

Now I can't find anything in the ADS docs that give me a scalar function that returns the RecNo().

Was I dreaming this?

[rdonnay]

I figured out a solution.

Xbase++ automatically stores the Recno() information for each record in the returned dataset because the dataset is applied to a workarea.

All I needed to do is call RecNo() for each row in the dataset.