Subject | subquery in filter |
---|---|
Author | l_gilbert_fr |
Post date | 2012-07-23T12:20:04Z |
Hi all,
I found a problem when I use a subquery in a filter (TIBO_QUERY.Filter).
I set the filter property as "(FIELD IN (SELECT F1 FROM T WHERE F2 = 'x'))" for example
The final statement for the filter generated by IBO seems to be like "(FIELD IN (SELECT, F1, FROM, T, WHERE, F2, 'x')"
I get an error on the 'x'...
Strange ?
bye
I found a problem when I use a subquery in a filter (TIBO_QUERY.Filter).
I set the filter property as "(FIELD IN (SELECT F1 FROM T WHERE F2 = 'x'))" for example
The final statement for the filter generated by IBO seems to be like "(FIELD IN (SELECT, F1, FROM, T, WHERE, F2, 'x')"
I get an error on the 'x'...
Strange ?
bye