Would you mind sending me a little sample app of this problem?
This would save me a lot of time if you would be so kind.
I'm about to release a new build and I would like to slip in the fix for
this.

Thanks,
Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of l_gilbert_fr
Sent: 02 January 2012 09:20 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Problem with SIMILAR TO in TIBO_QUERY.FILTER property

Thank you Jason for you reply, I always forgot the existence of this prefix
!!!

Laurent.

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...>
wrote:

>
> This is likely a bug in the IBO filter processing logic.
> For the time being you can preface the filter with a clause that causes it
> to directly pass through the filter unmodified.
>
> ::SQL::
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On

Behalf

> Of l_gilbert_fr
> Sent: 02 January 2012 05:07 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Problem with SIMILAR TO in TIBO_QUERY.FILTER property
>
> Hi all,
>
> I wonder if someone has the same problem I'm encountering.
>
> I update my application to use FIREBIRD 2.5 internal functions instead of
> UDF functions.
>
> In this way, I replaced regular expression search by the SIMILAR function,
> but even if my query works very well when I run it from IBEXPERT, I got a
> syntax error from IBO (4.9.14b32) about a bad parenthesis count.
>
> The filter looks like <<((XXX SIMILAR TO
> '[A-Z]?[A-Z]?10[[:DIGIT:]]{3}[[:ALNUM:]]*'))>>
>
> I made many tests without success but if I replace "SIMILAR TO" by a

simple

> "=", I don't get a syntax error anymore. This last test is only to

validate

> the syntax even if it produces a bad result.
>
> The exception message is :
> Syntaxe Invalide: parenthèse en trop ou en moins:
> (
> (
> XXX SIMILAR TO
> '[A-Z]?[A-Z]?10[[:DIGIT:]]{3}[[:ALNUM:]]*')
> )
>
> I think IBO doesn't show the first ')'.
>
> Regards,
>
> Laurent.