General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi all
>
>Can you suggest me how to issue the "BEGIN TRANSACTION" and "END TRANSACTION" using VFP 7.0 SQL Passthrough functions. How do I ensure that the transactions are safe and secure
>
>Thanks
>
>Raoshan
Hi Raoshan,
It is not recommended to send those commands directly through SPT. If you do, the majority of ODBC drivers stay unaware of the fact that you've opened a transaction and VFP doesn't know about that for sure. All this might work OK, but, in some scenarios, you may find your transaction committed earlier than you expected. Especially when TABLEUPDATE is executed for a multi-table remote view or a CursorAdapter.
The recommended way is to use SQLSETPROP(...,"Transactions",...) to switch to the manual commit mode and SQLCOMMIT()/SQLROLLBACK().
Thanks,
Aleksey.
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