Page 1 of 1

ADS record number in SQL query

Posted: Tue Jun 05, 2018 4:56 pm
by 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?

Re: ADS record number in SQL query

Posted: Wed Jun 06, 2018 11:41 am
by 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.