Jason,

I put a little program in the files area.
I use the last version of IBO with DELPHI XE and FIREBIRD x64 2.5.1.
The sample connect to EMPLOYEE.FDB database and open the employee table.
When you click on the filtered checkbox, the program assigns a filter on the table which used the SIMILAR keyword on the FIRST_NAME field.

The exception occurs when you activates the filter.

Regards,

Laurent.

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
>
> 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.
>