Transactions and TOracleQuery

[jpchausseau]

When using the TOracleDataset, one can set the CommitOnPost property to true to get the expected result. Now, with the TOracleQuery component, since this property does not apply, when are the changes committed? Does one has to explicitely handle the 'commiting' process, or does it occur automatically?

Thanks,

Jean-Paul

 

[Helene]

You need to call the commit method of the session which is connected to the OracleQuery.

In general, I think this is a better method, since it gives you control over transactions and enables you to ensure database integrity in a better way!