|Subject||RE: [IBO] Re: Bug in SQL Parser in IBO 5.5.3 Build 2067 ?|
|Author||IBO Support List|
Yes, you are correct. I will take these bug cases and fix them and put them in my regression test so that they will remain fixed.
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, July 18, 2014 7:14 AM
Subject: [IBO] 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.