All,

I wonder 'the Update settings' in the SQL Update Criteria tab in Foxpro.
We can specify that records be deleted and then replaced with the new values entered in the view (SQL DELETE then INSERT), or that server records be changed via the SQL UPDATE function supported by the server.
What is difference between 'SQL DELETE then INSERT' and 'SQL Update'? Which is the better?


Ricky