Write a stored procedure that does everything you want the sub-unit of work
to do. If the stored procedure fails at any point with an exception then all
that the stored procedure did will be cancelled. If it is successful then it
is part of the transaction and still subject to rollback.

THIS IS WHY FIREBIRD DOES NOT NEED NESTED TRANSACTIONS.

Thought I'd try and make this point clear.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "kj01135" <kj01135@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, November 04, 2002 9:39 AM
Subject: Re: [IBO] Transaction within transaction


> Thanks for your help.
>
> But how can I use two transactions components for a single
> TIB_Query? I want to insert records to this query within a
> transaction so that I can rollback all the insertion if desired.
> However I also want to edit these records (still within the
> transaction) in another transaction so that I can undo the changes.
> How can I set this up in IBObjects with Delphi?
>
> Regards,
> Kenneth
>
> > When FB1.5 appears, SavePoints will be possible.
> >
> > Until then, use separate transactions components, one for each
> transaction. Either one may
> > be committed/rolled back before the other.
> > --
> > Raymond Kennington
> > Programming Solutions
> > W2W Team B
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>