>As an old xbase (Clipper) programmer recently converted to VFP5 I am still using the SEEK command and indexes to find records belonging to a particular client (for example) to display in a grid on screen. I know now that by creating a query via Select SQL I can also do this as well.
>
>Question - is this the way to do it - by Select SQL I mean . Is it quicker on larger databases/reduce network traffic.
>
>Any general comments would be appreciated!
Bob,
It will be quicker providing you have indexes built on your main selection criteria. If, say, you have a client code and there is an index on the client code field, it will run MUCH faster. It uses some amazing background optimisation. This does not ALWAYS hold true about the indexes, but as a general rule, it would be faster.