Page 1 of 1
Commit with UniQuery
Posted: Thu 08 Jul 2010 21:19
by ericalves
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
Posted: Fri 09 Jul 2010 14:17
by bork
Hello
If you want to commit your operations manually then you should set the AutoCommit property of TUniQuery or TUniTable to False.
Posted: Fri 09 Jul 2010 14:45
by ericalves
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.
Posted: Fri 09 Jul 2010 15:14
by bork
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.
AutoCommit property for TUniQuery
Posted: Thu 15 Jul 2010 09:06
by roznicki
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.
Posted: Thu 15 Jul 2010 11:52
by bork
We will investigate the possibility of adding this feature in one of the next builds/versions of UniDAC.