General information
Category:
Coding, syntax & commands
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???)
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