Print Thread
Trasactions
#9434 08/08/07 01:08 AM
Joined: Aug 2007
Posts: 1
Brazil
R
Ronaldo Offline OP
Member
OP Offline
Member
R
Joined: Aug 2007
Posts: 1
Brazil
Hello,
I trying to create a code being used DOA compnents that makes something similar to this:
--------
...
var Level: integer;
begin
Level:=ADOConnection1.BeginTrans;
try
//do some database
//updating, deleting or inserting
ADOConnection1.CommitTrans;
except
on E:Exception do ADOConnection1.RollbackTrans;
end;//try
end;
...

How I begin an Transaction with DOA componentes?

tks,


Ronaldo

Re: Trasactions
#9435 08/08/07 08:44 PM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
A transaction is implicitly started with the first insert, update, delete or lock statement. It ends with a TOracleSession.Commit or Rollback.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 14 (0.009s) Memory: 2.4945 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 06:20:53 UTC
Valid HTML 5 and Valid CSS