Hi Paul > > Mike yearwood wrote: > > > The third parameter was not in 2.6 (Checked in FPD 2.6 but not in FPW 2.6) >
Quite right. 3rd parameter wasn't there, but seek() function was, which is what I thought he was asking. I forgot to mention one thing I used a lot. LOOKUP(). If you provide the 4th parameter which is the index tag name, it does a seek. It says it's not Rushmore optimizable, but then neither is SEEK. For example, if you have a filter, you can do a seek (or LOOKUP), and if the first seeked record doesn't match the filter, FP / VFP will spend a lot of time moving to the first matching record. So for Mike's original problem IF LOOKUP(table.pk,seekexpr,table.pk,'indextagname') = seekexpr would be very fast. It moves the record point just as seek does - so the result is the same. Mike Yearwood _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
