To explain a little further, using the SQL commands will not make a later client-server migration easier in the sense of having to change the data access -- you'll still have to modify your code to use SQLEXEC()s and perhaps to remove VFP-specific SQL constructs.

However, the benefit to using SQL now is: if the rest of your application is designed to work in a record-by-record fashion (like xBase apps usually are), you will have to redesign modules to work with set-based data. Using SELECT from the start avoids this.
zahid

>There's no set rule on that, Plinio. It would depend on a number of factors. There are times where SEEK works best and times where SELECT works best. If you are designing a solution that you might have to scale up to a server database, then consider using the SQL commands and views where possible to minimize problems migrating the data later.
>
>>Shoud I replace the use of : SEEK,REPLACE,DELETE and use SELECT * FROm where, Update WHERE, and DELETE FOR
>>
>>It's a good artinative??
>>What's the diferences?? (speed,integrity???)