Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flexible search/find form?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00172137
Message ID:
00172226
Views:
24
Steve,
I would not assume that a SQL Select is slow - you may be surprised if you try it. Of course the speed depends on the query and what appropriate indexes the database engine has to optimise the query with. I for one am a convert to the SQL way of doing things - and I suspect we will see more of it in our futures. <g>

>Jim,
>
>Thanks for the advice.
>
>I assume the LOCATE command also would be preferable to the SQL SELECT command relative to performance and my primary objective of taking inputs from a form to search for matching records.
>
>It will be much easier to use the LOCATE command. I was hoping I could use it, but was concerned that it was a lot slower than SEEK. So that's good news. It makes my life much easier.
>
>Thanks again.
Previous
Reply
Map
View

Click here to load this message in the networking platform