For sake of saving me a little time, please put together a very simple app
that I click a button and it errors out.
I can get this fixed fairly quickly if you do this part of it.
Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <laurent.gilbert@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, September 18, 2001 6:03 AM
Subject: [IBO] filter problem


> 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...)