Subject RE: [IBO] Re: Bug in SQL Parser in IBO 5.5.3 Build 2067 ?
Author IBO Support List
Post date 2014-07-21T12:39:16Z
I have completed the work required for this and the fix will be in the next release.
 
If you would like a patch for the existing version, let me know.
 
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, July 18, 2014 12:42 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Re: Bug in SQL Parser in IBO 5.5.3 Build 2067 ?

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

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Friday, July 18, 2014 7:14 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Bug in SQL Parser in IBO 5.5.3 Build 2067 ?

Hi Robert,

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.



 Best Regards,