Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GO TOP before SEEK?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00471932
Message ID:
00472781
Views:
27
>>Someone told me to always GO TOP before doing a SEEK as follows:
>>
>>SEEKID = seekaddress
>>SELECT mytable
>>SET ORDER TO myid
>>SEEK SEEKID
>>IF FOUND()
>>ENDIF
>>
>>Should I always put a GO TOP or GOTO TOP before the SEEK SEEKID command?
>>I did not think it was necessary. Am I right or am I wrong? Thanks for the info.
>
>I wonder why so many folks use SEEK at all these days. Between LOCATE and SQL and SCAN (none of which require a SET ORDER), why SEEK at all? Just curious, in case I'm missing something. :)

Because it's the fastest! :) I remember seeing here a thread, which discussed speed difference between various FoxPro commands. It was about half of year ago and I didn't remember the thread title, unfortunately...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform