ADS record number in SQL query

Xbase++ 2.0 Build 554 or later
Post Reply
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

ADS record number in SQL query

#1 Post 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?
The eXpress train is coming - and it has more cars.

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADS record number in SQL query

#2 Post 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.
The eXpress train is coming - and it has more cars.

Post Reply