General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only