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

[Non-text portions of this message have been removed]