Use case: direct rollback

[icegood]

Hi.
I have DOA v 4.1 and I have an TOracleDataset which works with next parameters:
CachedUpdates=FALSE
CommitOnPost = FALSE

So, when i post record it is written to DB. After that it might be situation that i will roll back my changes. How can revert my TOracleDataset to meaningful state in case of rollback? E.g. in dsInserting for new record?

 

[Marco Kalter]

If CachedUpdates is False, then you would need to refresh the dataset to make it consistent with the database after a rollback.

 

[icegood]

Sorry, but i didn't specify exactly my use case.
I don't need refresh as i need to try to re-commit local uncommitted changes. I don't want lost them after first failed try.

 

[Marco Kalter]

In that case you need to use CachedUpdates for the dataset(s). See also the User's Guide topics about:

TOracleDataSet.CachedUpdates
TOracleSession.ApplyUpdates
TOracleSession.CommitUpdates
TOracleSession.CancelUpdates