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