Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread V3>V4: Transactions
Tue, Oct 20 2009 4:19 AMPermanent Link

"Alessandra"
In V3 i had such a procedure (simplified):

TempDB.StartTransaction;

with MyTable do begin // mytable
databasename:='Temp'; // Temp is the name of TempDB
tablename:='Ciao';
if exists then deletetable;
createtable; open;
append; edit;
<something>
post; close;
end;

TempDB.Commit;

in V4 the same procedure raises an exception on Commit because "there is no
active transaction".

Is there something wrong in my proc, or has the transactions management
changed from V3 to V4 ?

Thanks!
Tue, Oct 20 2009 6:12 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alessandra,

<< in V4 the same procedure raises an exception on Commit because "there is
no active transaction". >>

See this section of the manual under "Incompatible Operations":

http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=d&version=7&category=1&topic=12

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Oct 20 2009 12:18 PMPermanent Link

"Alessandra"
Tim Young [Elevate Software] wrote:
> See this section of the manual under "Incompatible Operations":

ah ok Tim, so the problem was about the deletetable/createtable, which
aborted the transaction. Thank you very much!
Image