What about the other occurences of the same statement in IB_Components
and maybe other source modules ?

-------------------------------------------------------------------------

----- Original Message -----
From: "Johannes Pretorius" <johannes@...>
To: <IBObjects@yahoogroups.com>
Cc: "Willem Goosen" <willem@...>; "craig Arenson"
<craigA@...>
Sent: Friday, April 07, 2006 4:38 AM
Subject: [IBO] IBOQuery Locate bug IBO 4.6A


> Good day All
> 0-=0-=0-=0=-=-0
>
> I have found a problem/bug with IBOQuery component
> if you use the locate method.
>
> Basically if your query is something like
>
> select * from A order by column1
>
> and you do a locate on a field in the dataset then you get a error about
> an invalid WHERE clause.
>
> I debugged the problem to the following
>
> //==============================
> Unit : IB_Components
>
> line : 31374
>
> WAS
> if not Prepared or not SQLIsValid then
>
> CHANGED TO
> if (not Prepared) or (not SQLIsValid) then
>
> //=================================\
>
> This basically made that the IF was ENTERED although the Prepared and
> SQLIsValid flags ARE TRUE.
>
> Thus if the brackets is added then the if is skipped and the fucntion
> works as it is suppose to.,
>
> I hope this helps somebody else.
>
> Have a nice day
>
>
> Johannes Pretorius
> (Programeerings Departement- Promed)
>
> Tel : +27 11 607-3300
> Faks : +27 11 622-6939
> webtuiste : http://www.promed.co.za
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you are not the intended recipient, any review, re transmission,
> disclosure, copying, modification or other use of this email message or
> attachments is strictly forbidden. If you receive this email message in
> error, please contact the author and delete the message and any
> associated files from your computer. Also the contents of this e-mail
> is considered confidential.
> Thank you
>
>
>
> ___________________________________________________________________________
> 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 !
> Yahoo! Groups Links
>
>
>
>
>
>
>