Committing in a multi-tier application

[nboodram]

Hi,

I'm converting a BDE multi-tier app to DOA. Using D7, DOA 3.4.6.4.

I've read a few archived posts where first it seems as if you need to explicitly commit when using DOA. Then I read another post where if you call TClientDataSet.ApplyUpdates then a commit is automatically performed. Can someone confirm?

Thanks,
Natalie

 

[Marco Kalter]

A TOracleDataSet will implicitly commit when posting records, unless CachedUpdates is enabled. When using CachedUpdates, or when connected to a TDataSetProvider, a commit will occur when ApplyUpdates is called.

For all other components (TOracleQuery, TOraclePackage, and so on), you need to explicitly commit your transactions.

------------------
Marco Kalter
Allround Automations