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.