Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can use seek to perform like locate withg dowhile?
Message
From
14/09/2006 09:57:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How can use seek to perform like locate withg dowhile?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153661
Message ID:
01153661
Views:
59
How can I duplicate the following code using the seek command:
 SCAN
 SELECT Invoice
 LOCATE FOR in_code = lnCustCode
   DO WHILE FOUND()
     do some code
     CONTINUE
   ENDDO
 SELECT sometable
 ENDSCAN
The is extremely slow as this codes is already in another loop and therefore a locate for the whole table is execute each time.

Thanks in advance.
Stuart Reid

True nobility lies not in being superior to another man, but in being superior to one’s previous self
Next
Reply
Map
View

Click here to load this message in the networking platform