I think someone already mentioned GO BOTTOM. But just in case there is an index set, I think you might want to do a SET ORDER TO 0 just before doing the GO BOTTOM. And of course, if you do that, you might want to restore the index after the GO BOTTOM. Something like:
cIndex = ORDER() set order to 0 go bottom set order to (cIndex)
On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko gene@shaw.ca wrote:
Hello:
I have a situation in my app where I am having to pick up whatwill presumably be the last row in a table. Mind you, the general situation is that it might not be if in a multiuser situation.
With the current situation, I can use an index to find that rowreally fast.
BUT ... What if an index is not appropriate? Is there any way to do aLOCATE backwards (or something equivalent)? (The table has 186,574 rows currently so searching backwards would definitely be worth it.) I do not think there is such a critter, but maybe, you know better?
Sincerely,
Gene Wirchenko
[excessive quoting removed by server]