Thank U again, Jason.

I'll wait till next Sub/Release, else I'll be chasing my own tail :)

One question, if you don't mind.

Done some testing and found a 20% speed improvent by eliminating
all the "TOKEN" and RESERVED WORDS checks and fixes in IB_PARSE.

Just three/four additional IF's required. I know it will be my
risk, if I trap myself on a keyword or a "SPACE FIELD" column or such.

However with a little bit of planning one should be able to avoid
the RESERVED WORDS in the Database and gain 20% speed improvement
by setting a global flag "MYRISK" somewhere on the Connection which
can be picked up in IB_PARSE.

Just a thought. What do you think ?

Best Regards
Hans

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

Jason Wharton wrote:

>
> 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
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/