At 12:54 AM 11/02/2007, you wrote:

>HI!
>I made a litle program to test this.

You can access this file at the URL:
http://groups.yahoo.com/group/IBObjects/files/Bug%20Testing%20Applications/teste.zip


Thanks, Omar, it is an excellent test program and demonstrates well
the problem described.

As far as I can tell, a bug has been introduced into the TDataset
components, probably by the changes that were done to handle derived
tables. At some point in parsing the TIBOQuery SQL, the parser is
trying to treat embedded SELECTs inside existence expressions as
though they were derived tables. It must be told to ignore
them. Only the server is interested in existence tests in a WHERE clause.

Needs more work, Jason. Omar corrected the qualifier errors in the
original report and it has not improved the problem on the IBO side.

Helen