Good day Salvatore
-=00-=-0=-0=-0=-=0

I also thought that, but I could redo the error , over and over again and then when stepping
to this statement I looked at the values and BOTH WAS TRUE. BUT it STILL entered the
statement regardless, I then changed it as I have shown and then it worked correctly

Basically I have an app (Delphi 3) that does a query that is as follows
"select * from table_a order by key1"
on a table with a IBOQuery component (Chached updates = true), key1 field
is the only field in the keylinks table and I do a LOCATE on key1. It then CREATES (I have seen this and will redo this if needed)
a WHERE clause AFTER the order by part of the query to try and get the key. I then narrowed it down to the
if clause and after the changed it all worked correctly.

If more information is required., Please tell me and I will try and write an sample app to prove this.

Thanks in Advance

Johannes Pretorius


At 07:03 PM 07/04/2006, Salvatore Besso wrote:

>hi Johannes,
>
>I'm sorry but from
>
> if not Prepared or not SQLIsValid then
>
>to
>
> if (not Prepared) or (not SQLIsValid) then
>
>absolutely nothing changes. The two statements are absolutely equal and
>both return the same result.
>
>Regards
>Salvatore
>
>
>
>___________________________________________________________________________
>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
>
>
>
>