I am saving a invoice with several tables in a single transaction. If the transaction fails and the user corrects the problem, I get a concurrency error when attempting to save.

I noticed that when I call TransactionRollback() the RowState of the data I'm attempting to save is not restored. The RowState remains Unchanged and the IsChanged() is false.

I was thinking that if I rolled back a transaction, it would all roll back. Am I missing something?

Thanks,
Jeff Corder