|Subject||Re: Bug in SQL Parser in IBO 5.5.3 Build 2067 ?|
Thanks for replying. But, the additional brackets () should not affect the results. And is more easily do the reverse parser in SQL Filter through regex.
Anyway, error also happens in the SQL filter bellow:
UPPER([Name]) LIKE '%RAFAEL%'
The Filter Parser in IBO can not interpret the square brackets in this case. In Delphi Docs, the square brackets can be used when a field name contains spaces.
In addition, the IBO docs promises that the Filter property will work the same way as any native TDataSet descendant, such as TQuery, TTable and TClientDataSet. And it seems that is not the case.