Hi all,

In my application, I use TIBOQuery component (last 3.6 version) and
filter property.
My window has a grid and "filter shortcuts". When user activate
a "filter", I modify filter property of the IBOQuery.
Filters could be combined.

Filters are :
1) "(TNATU_EST_CABLE = 1)"
2) "(TNATU_REF_TECHNO = 'O')"
3) "(TTEQU_NOM LIKE '%SL%')"
4) "(TEQU_REF_DERETATEQU > 0 AND TETATEQU_REF_SITE IS NOT NULL)"

Users can select filters 1 and 2, or 1, 2 and 3, etc... It works very
well !

The only problem is when filters 3 and 4 are combined !
The filter statement I set in filter property was : "(TTEQU_NOM
LIKE '%SL%') AND (TEQU_REF_DERETATEQU > 0 AND TETATEQU_REF_SITE IS
NOT NULL)".

This is the IBO error that occurs :

Invalid syntax : extra or missing parenthesis:
(
TTEQU_NOM IS NOT NULL
LIKE '%SL%'
)
AND
(
TEQU_REF_DERETATEQU > 0
AND
TETATEQU_REF_SITE
)

I don't know why "is not null" was moved !

If someone has an idea...

Laurent.
(PS: sorry for my poor English...)