with cached updates you can selectively remove inserts or updates or deletes
from the cache at anytime before you commit.
Alan

> -----Original Message-----
> From: kj01135 [mailto:kj01135@...]
> Sent: Tuesday, 5 November 2002 21:18
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Transaction within transaction
>
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > 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.
>
> Hmm.., let me explain a bit more.
>
> A user just inserted ten rows of data in a dbgrid. He can rollback
> all these ten rows without problems (within a transaction control).
> Without committing first, he also edited some rows of data and now
> he wants to rollback to the point where no editing has occured. If
> he click the Rollback button, all the ten records will disappear
> because the insertion has'nt been committed. The Cancel button
> doesn't work since it only affect to single row of data.
>
> How can I do these interactively? Can it be done using SP? Do I need
> to use Cache Update as suggested by Paul Hope?
>
> Thanks for helping me.
>
> Kenneth
>
>
>
> __________________________________________________________________
> _________
> 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/
>
>