| Subject | Re: [IBO] Filter |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-09-18T22:21:03Z |
At 03:16 AM 19/09/2007, you wrote:
filter is being appended. That actually matters...
1. Do you need to include a relation qualifier to CLIENT_NAME? (the
relation name or relation alias that is used for that table in your
SELECT statement).
2. Try putting parentheses right around the whole thing. Filters
are appended to any existing WHERE clause so it's possible the
revised WHERE clause needs to isolate the filter.
3. Put in a monitor dialog. It's an amazingly useful way to resolve
"weird", "strange", etc.
Helen
>Hi!Missing from your posting is the SELECT statement to which this
>
> Do someone know what's wrong with this filter expression?
>
> UPPER(CLIENT_NAME) LIKE 'JOHN%'
>
> IBO raises an error everytime asking for parenthesis... Very strange.
>
> My configuration: D7 + F1.5 + IBO4.8.7
filter is being appended. That actually matters...
1. Do you need to include a relation qualifier to CLIENT_NAME? (the
relation name or relation alias that is used for that table in your
SELECT statement).
2. Try putting parentheses right around the whole thing. Filters
are appended to any existing WHERE clause so it's possible the
revised WHERE clause needs to isolate the filter.
3. Put in a monitor dialog. It's an amazingly useful way to resolve
"weird", "strange", etc.
Helen