Jim,

In addition to Craig's point, you should also know that VFP does not provide true transaction processing. That is, if your computer crashes while committing a transaction it is possible for part of the transaction to be committed. This will only happen if your computer or application crashes while VFP is actually writing the transaction to disk when you END TRANSACTION, but the larger the transaction the higher the likelyhood of this happening. If you need to absolutely guarantee that the transaction is completely committed or completely rolled back you'll need to use a server database like SQL Server or Oracle.

>Howdy (Texas talk for "Hi All")
>
>I have a situation where I would like to surround some multi-table transactions with BEGIN TRANSACTION/END TRANSACTION and rollback to the previous table states if the entire series of multiple transactions is not successful.
>
>Since this will require the opening and closing of many, many tables in at two differnt sites, and the creation and destruction of multiple cursor, I am wondering if it is even practical.
>
>Any thoughts or advice would be appreciated.
>
>TIA