Hi Sylvain,
>Since you will probably use remote view with a different back end, you won't need to modify your REPLACE lines because, AFAIK, you can still use them with remote views.
>Everyone has given you good points to compare. This is only my .02 worth. I try to use UPDATE - SQL and typically use SQL code whenever possible. If the app ever needs to go to a back end other than VFP I suspect that the code would migrate easier because there are far less changes to make.
Exactly! I use views (local and remote) for updates based on user input and therefore use REPLACE. (No locking issues and performance should be better.) Whenever I do an update against a table, THEN I use UPDATE.
Bill Armbrecht
VFP MCP