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]