>It won't matter how you setup transactions as VFP is not supported directly by the DTC. You have a couple of choices --
>
>- Manage the transactions yourself in the data components
>- Create a Compensating Resource Manager for VFP that can work with the DTC.
>
>Option 1 is probably the easiest.
>

That is what I figured. Did you ever get far enough with ComCodeBook to have an example of a Data component that handles Transactions?

Also are you indicating that if we move to SQL Server the transaction portion of ComCodeBook would work? And if so, how does ComCodeBook handle transactions across Tables for one transaction. lets say a modification of a record needs to have data deleted from one table and added to another table. If the deletion goes, but the add does not then how does ComCodeBook know to roll back?

Thanks for your time on this.


>>
>>Sorry for the delay in responding. I have been putting out a few brushfires. The Backend database for the testing period is VFP 7.0 SP1.
>>