CODEWITHSUNDEEP
progress-4glopenedge
Tanner Sorensen
Tanner Sorensen

Reputation: 59

grab record by inherant table sequence index

I'm kind of new to Progress and finding it really hard to look up some existing solutions to problems, since the keywords are so ambiguous.

I digress, is there a way to access a record in a table by it's sequence index inside of the table, without having to create a field and manually track it?

Thanks

Upvotes: 1

Views: 629

Answers (2)

Tim Kuehn
Tim Kuehn

Reputation: 3251

While it's not a direct answer to your question,

1) each table has a ROWID and RECID value which can be used to find it directly without adding a new field. It's value can change over the course of time, so it's best to only use it for a single session. So once you know which record is of interest, your program can go directly back to that record w/out having to do a potentially slow search.

2) Progress also added the "table-scan" phrase, which returns the records in db order. I forget which version it was added though, so it may or may not be usable on your platform.

3) Another possible approach would be to create a TT and populate that with links to the main DB, and then sort it in the order you want.

Upvotes: 3

Tom Bascom
Tom Bascom

Reputation: 14020

There is no such capability. You need to create a field that captures whatever attributes you feel makes up an inherent order.

Upvotes: 1

Related Questions