This is a difficult issue. On the client side I don't have the mechanisms to
equally apply the same sorting rules. Because of this I have added hooks for
you to plug in a method of text comparison that is consistent with what you
are using on the server. This is something that you will need to take up in
the Firebird forums to figure out how you can get the text comparison it
uses inside your application. I hope someone can at some point figure this
out. It's on my list to do but since all of my applications are in standard
ANSI characters it won't be a personal priority.

Regards,
Jason Wharton

----- Original Message -----
From: "Andrei Luís" <compuvale.software@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, June 26, 2009 8:01 AM
Subject: Re: [IBO] Re: Problem with TIB_Lookupcombo and null rows


Anyone?

Today I did a test: I specified the collate PXW_INTL850 for the field I use
in TIB_Lookupcombo, and the search works fine. But by doing this, I lost the
correct sort for my language.

Anybody has another solution for this issue?

Should I consider this a bug in TIB_Lookupcombo or in FB?

Regards,
Andrei

2009/6/24 Andrei Luís <compuvale.software@...>

> Thanks for you help sonic3076.
>
> But the problem is not ordering, this seams to be ok, the problem is that
> the search not work.
>
> I'm not using order by, I'm using OrderingLinks, as far as I known this is
> the correct way to search on TIB_Lookupcombo, right?
>
> Regards,
> Andrei
>
> 2009/6/24 sonic3076 <o.wurdak@...>
>
> Hello
>> Perhaps the problem lies in the different ordering of NULL between FB1.5
>> and 2.x (look at http://www.firebirdsql.org/manual/nullguide-sorts.html )
>> Try to add a "Nulls last" to have the same ordering as in FB <2.x.
>>
>>
>>
>> --- In IBObjects@yahoogroups.com, Andrei Luís <compuvale.software@...>
>> wrote:
>> >
>> > Hello,
>> >
>> > I'm using IBO 4.8.7 on Delphi 2006 Win32.
>> >
>> > This week I finnaly moved to FB 2.1.2, I was working with FB 1.5.5.
>> >
>> > What I did to my base:
>> > - with FB 1.5: extract DDL metadata, and change some collates from
>> > PXW_INTL850 to WIN_PTBR
>> > - with FB 2.1: create the new FDB file and pump data from the FB 1.5
>> > FDB
>> > file using IBDatapump
>> >
>> > After that, I experienced some search problem using TIB_Lookupcombo,
>> > consider the above fields:
>> >
>> >
>> > NAME varchar(50) collate WIN_PTBR (with FB 1.5 the collate was
>> > PXW_INTL850)
>> > CONTACT varchar(30) collate WIN1252 (same collate on FB 1.5)
>> >
>> >
>> > Well, nothing was changed in Delphi Project, so, TIB_Query and
>> > TIB_Lookupcombo properties are OK.
>> >
>> > After some tests, I realized that the problem is on NULL values at the
>> > searched fields. If I have two or more lines with NULL values in the
>> > searched field, the search don't work. I can click on TIB_Lookupcombo
>> and
>> > navigate on data, it's all there, but if I type something on keyboard,
>> > nothing happens.
>> > I run 'DELETE FROM MYTABLE WHERE NAME IS NULL', and the search is
>> working
>> > again. I inserted one field with null value and search is ok, but if I
>> > insert one more null value the search is gone again. I got the same
>> behavior
>> > independent the collate. But If I use the original FB 1.5 base, running
>> on
>> > FB 2.1 server, the nulls rows don't affect the search.
>> >
>> > What can I do? I can delete the rows that have null in name collumn,
>> > but
>> I
>> > can't delete the rows that have null in collumn contact. And I'd like
>> > to
>> > maintain the collate WIN_PTBR for ordering purposes.
>> >
>> > Is there any other sollution to this issue?
>> >
>> > Thanks,
>> > Andrei