Commit with UniQuery

ericalves · Post by **ericalves** » Thu 08 Jul 2010 21:19

BDE previously used, the changes only went to the bank when executing SQL COMMIT, now UniQuery data already go to the bank when executing "UniQuery.Post. I use "UPDATE NOWAIT" to lock the records in the register, so when I run. Post, performs the COMMIT and removes
LOCK, would set this up? For the data only being sent to the bank after the COMMIT.

Unidac use with Oracle and Delphi 7

bork · Post by **bork** » Fri 09 Jul 2010 14:17

Hello

If you want to commit your operations manually then you should set the AutoCommit property of TUniQuery or TUniTable to False.

ericalves · Post by **ericalves** » Fri 09 Jul 2010 14:45

I do not know what version you are referring, but in mine it's 3.00.0.6 not found the property that you mentioned.

bork · Post by **bork** » Fri 09 Jul 2010 15:14

Sorry, this option is available in ODAC.

In the UniDAC components to commit changes manually you should start transaction manually:

Code: Select all

begin
  UniConnection1.StartTransaction;
  
  ... // change your data

  UniConnection1.Commit; 
end;

All changes will be posted to database after calling UniConnection1.Commit only.

roznicki · Post by **roznicki** » Thu 15 Jul 2010 09:06

Please add AutoCommit property for TUniQuery (and others) in future relases of Unidac. Please. I have done it in my sources but I think it should be part of standard Unidac. At least for compatibility with BDE.

bork · Post by **bork** » Thu 15 Jul 2010 11:52

We will investigate the possibility of adding this feature in one of the next builds/versions of UniDAC.