>I have trouble understanding the following.
>
>How do transactions work with client/server? Do you continue using the VFP commands,
BEGIN TRANSACTION, etc., or do you have to define something on the database server?
If you're connecting through ODBC (e.g. SQLCONNECT(), SQLEXEC()) you can use SQLCOMMIT(), SQLROLLBACK() and (optionally) SQLSETPROP(). Or, you can pass the backend's native transaction control commands via SPT.
Another common approach is to call a back-end stored procedure, which has been designed to handle transactions natively.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up