If you are calling ExecuteSQL multiple times and want to confirm that all ExecuteSQL are successful before committing the processing, you can use transaction processing.
To start a transaction, call BeginTrans, then call ExecuteSQL as many times as necessary, and finally call CommitTrans.
If you want to abort the entire transaction, call Rollback.
It is an error to call BeginTrans again without calling CommitTrans or Rollback.
If you want to perform transaction processing, connect with Connect (dsn, dataBase, user, password).
When connecting with Connect (actionName), multiple clients share a single connection, so transaction processing may not work properly.
|