Try go bott

Op wo 3 jul. 2019 om 12:48 schreef Gene Wirchenko gene@shaw.ca

Hello:

  I have a situation in my app where I am having to pick up what

will 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 row

really fast.

  BUT ...

  What if an index is not appropriate?  Is there any way to do a

LOCATE 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]