>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!
SELECT-SQL is not quicker if you actually looking for few records, i.e. your SEEK/SKIP loop is short enough. However, for small tables the difference is negligible.
Edward Pikman
Independent Consultant