Thank you for submitting your request to BREW Support. Your service request number is 18333905. Please use this number for future reference. If at any time you wish to update your case, please reply to this email or send us an email with "UPDATE 18333905" in the Subject: line. Doing so will automatically update our records.

Thank you.
BREW Support Team.


[THREAD ID: 1-4YMHF]

-----Original Message-----
From: 0005340458@...
Sent: 8/24/2003 12:18:55 PM
To: brew-support@...
Subject: [IBO] "Transaction has already been started"

I've the following error "Transaction has already been started" (when an
exeption has been raised before) as result of this code:


DBO_DataModule.IB_Transaction1.StartTransaction;
FSQLCommand.InsertSQL.Text := sSQL;

try

FSQLCommand.ExecSQL(ukInsert);
DBO_DataModule.IB_Transaction1.Commit;

except

{this line do not closes transaction}
DBO_DataModule.IB_Transaction1.CancelAll;

{this line closes all queries too}
DBO_DataModule.IB_Transaction1.Close;

end;


How to close a TIB_Transaction component without have the same effect on the
Queries asociated with it?




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/