Subject MORE Re: [IBO] Problem setting filter to TIB_Query
Author Helen Borrie
At 01:47 PM 28/03/2006, you wrote:
>At 01:19 PM 28/03/2006, you wrote:
> >Nope, still the same, IBO adds commas in between every token even after
> >adding the full table specifiers and additional brackets. It the fails with
> >an expception:
> >
> >"Invalid syntax: extra or missing parenthesis"
> >
> >And it's not wrong number of parenthesis but the added commas.
> >Should I make a test case?
>Yes, please do. Would you use the employee database, please, and
>just post your project sourcecode in a zipfile (no executables!!).

OK, I made a test case, using the Employee and Employee_Project
tables and I confirm that the filter parsing does not handle the
embedded subquery at all. NOw to find out whether that is a bug or
just a limitation. I'll send a heads-up to Jason.