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