Subject Re: [IBO] Rollback
Author Jason Wharton
Ok, I was able to reproduce this problem with the information below and I
have put together a fix that will make it work correctly now. Let me know if
you want an immediate patch or if waiting until the next sub-release is
sufficient.

Thanks for pointing this out!

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


----- Original Message -----
From: <hans@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, August 18, 2001 5:23 PM
Subject: Re: [IBO] Rollback


> Sorry, No change,
>
> Small TIBOQuery called TEST hookedup to Grid
>
> 'select * from test for update'
>
> CREATE TABLE TEST (
> A INTEGER NOT NULL
> , b INTEGER
> , c INTEGER
> , d INTEGER
> ,
> PRIMARY KEY ( A )
> )
>
> 1. 'Delete from test'
> 2. TEST.IB_Transaction.Commit;
>
> 3. TEST.Prepare;
> 4. TEST.Open;
> // Grid shows an empty data set
> 5. TEST.Append;
> 6. TESTA.value := 1;
> 7. TEST.Post; // Grid shows A = 1
>
>
> 8. TEST.IB_TRansaction.RollBack;
> 9. if TEST.IsEmpty then
> ShowMessage('Empty'); // Never gets displayed
>
> 10.TEST.Refresh; // if this statement is not executed the
> grid will not refresh and show an empty
> dataset
>
>
> Hope this helps.
> Best regards,
> Hans