In order to Transaction.RollBack, I have then set as follows:

TMSServer.Connected := False;
IBOTransaction.AutoCommit := False;
IBOTransaction.Isolation := tiCommitted;
IBOTransaction.ServerAutoCommit := False;
...
DataBaseName and Password stuff
...
TMSServer.Connected := True;

Best regards
Hans

===============================================

Jason Wharton wrote:

>
> What is the query's commit action set to?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: <hans@...>



> To: <IBObjects@yahoogroups.com>
> Sent: Saturday, August 11, 2001 1:43 PM
> Subject: [IBO] Rollback
>
> > Found a small challenge in RollBack.
> >
> > When starting with an Empty Table, after inserting a Row, then Deleting
> > the same Row, a RollBack doesn't Refresh the Table.
> >
> > However starting with a Table populated with some Rows, then Deleting
> > the same or other rows, or even all rows, a RollBack DOES Refresh
> > the Table.
> >
> > Best Regards
> > Hans
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/