Re: [DUG]: Transactions

[Terry Johnson]

I've traced through some code. If you're using the query to return a dataset, then while the query is active the transaction is active. If you use the ExecSQL method, and a transaction is not active, then it is started and committed automatically.

Terry

Chris Reynolds wrote:

 
11/09/2002 12:31:27 p.m., Terry Johnson <[EMAIL PROTECTED]> wrote:

  

I'm using Firebird, and am unsure of something with the transaction 
mechanism.

When I do a select then update, I need to follow with a commit, but if I 
just do an update, then a commit I get a 'Transaction not active' error. 
So what's the deal? Does a solitary update have an automatic commit?

Terry

    

all updates are autmoatically committed unless you have started an explicit transaction.

I believe you can set a connection property to disable implicit transactions but I've never used it.




---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/