Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Locate
Miscellaneous
Thread ID:
00091875
Message ID:
00092014
Views:
26
>If I have a table that has 500,000 records in it and I locate for number 400,000. Is there a way to locate for 400,500 without having to have VFP look at the first 400,000 records. continue() I know is used iuf you are searching for the same parameter, but I want to change the search parameter and continue where the last search finished. Also seek will not work because I want to search for multiple condition. Any suggestions?

If you truly want to search just the remainder of the table, use
LOCATE for FieldN = NewVar WHILE !eof()
That will force the LOCATE to start at the present record. Be careful, the remaining records will vary depending on the index set!

HTH
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform