I have the sample app you made, very nice work, and the problem reproduces
for me.

I believe the difference is going to boil down to a difference between the
sorting of the records from the server compared to the sorting logic I use
on the client.

In order to rectify this, I foresee that it will become necessary for the
Firebird/InterBase client to provide string handling mechanisms to stay in
sync with server string handling. This will affect collation,
transliteration, comparison, etc.

Does anyone know if there are efforts to provide this or are all developer
on their own to provide customized collation, transliteration, etc.
functionality?

Regards,
Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Antti Kurenniemi
> Sent: Friday, December 01, 2006 11:29 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Searching problem
>
>
> >>Hello there.
> >>
> >>I have a problem with searching in IBO. If I have names in
> a table like:
> >>
> >>Andy Warhol Knock-Off Ltd
> >>Ad-Astra Corporation
> >>Ad Infinitum
> >>Advanced technologies Inc
> >>Adagio and Sons
> >>Beryl's Beryllium Supermarket
> >>
> >>...and I use a TIB_IncSearch with SeekNearest set to True,
> then searching
> >>for "adag" will find "Adagio and Sons" just fine, but searching for
> >>"adagio"
> >>will find "Ad-Astra Corporation". The search will also stop
> at ad-astra
> >>corp
> >>is I enter "Adagio and Sons", even though it's a full match.
> >>
> >>I'm using IBO 4.6 and FB 1.5.3, so I don't know if this
> works different in
> >>later versions. I can reproduce this with a very small
> project, using a
> >>table with name column only. OrderingItems would be
> >>
> >>Customer Name=name
> >>
> >>and OrderingLinks simply
> >>
> >>name=1
> >>
> >>Any ideas?
> >
> > What's your setting for SearchKeyByKey?
>
> False, I use Enter key to execute the search.
>
>
> Antti Kurenniemi