Subject Re: [IBO] Problems with searching and filtering
Author Antti Kurenniemi
Not really, just something with the string mathcing. But if I can help with
testing something, just let me know.


Antti Kurenniemi

----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 26, 2007 10:38 PM
Subject: RE: [IBO] Problems with searching and filtering


> I'll review this and see if I can discover something I have missed.
>
> Do you suspect anything?
>
> Jason Wharton
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Antti Kurenniemi
>> Sent: Thursday, March 22, 2007 9:49 PM
>> To: IBObjects@yahoogroups.com
>> Subject: Re: [IBO] Problems with searching and filtering
>>
>>
>> [snip]
>> >> Searching for "adag" will correctly find "Adagio and
>> >> Sons", but if you enter "adagio" as the search criteria,
>> >> it will stop at "Ad-Astra Corporation" which is wrong.
>> >
>> > There isn't anything more I can do about the sorting
>> > problem.
>>
>> I don't understand why. This works as expected with FIBPlus
>> and UIB, only
>> IBO does it differently.
>>
>>
>> [snip]
>> >> Invalid syntax: extra or missing parenthesis:
>> >> (
>> >> id in ( select, customerid, from, custtoclass,
>> >> where, classid, in, (, 1, 2 )
>> >> )
>> >> )
>> >>
>> > I am working on a new sub-release and this issue will be resolved.
>>
>> That's great.
>>
>>
>> > For the time being, as a workaround preface a direct SQL filter
>> > with ::SQL:: (see help file for exact syntax) and you can avoid
>> > IBO doing any parsing of the filter itself. It will just
>> patch in your
>> > filter as direct SQL in the WHERE clause.
>>
>> Thanks, I'll give it a go - I hadn't noticed that possibility at all.
>>
>>
>> Antti Kurenniemi
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>