Subject | Re: [IBO] Rollback |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-08-19T00:23:22Z |
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
==============================
Jason Wharton wrote:
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
==============================
Jason Wharton wrote:
>
> How is this in the latest sub-release 4.2 Eb?
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: <hans@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Saturday, August 11, 2001 4:37 PM
> Subject: Re: [IBO] Rollback
>
> > Just a small interesting thingy, starting with empty table
> > and after inserting of one record, followed by deletion of the
> > same and then
> >
> > RollBack;
> >
> > if TEF.IsEmpty then <==== is not True, eventho the table
> > should be empty at this point ?
> >
> > TEF.Refresh;
> >
> > Best Regards,
> > Hans
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/