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 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/cacw6n4tvxpkem9q4jupjsv6babsjgio_sufdq18ujytqtiv...@mail.gmail.com ** 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.
