At 12:19 2019-07-03, Ted Roche <[email protected]> wrote:
On Wed, Jul 3, 2019 at 12:48 PM Gene Wirchenko <[email protected]> wrote:
> 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?
SET FILTER TO <condition> && optional
GO BOTTOM
SKIP -1 && as needed, this LOCATEs backwards
Argh! I should not have missed that since I am not an
anti-SET-FILTER-TO-ist. Thank you.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: https://leafe.com/archives/byMID/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
