I've not carefully read the thread, but I can tell you that if you have an=
alias upon a column (i.e. select name as first_name from customer), then yo=
u can use the alias in the OrderingItems, but if you use the OrderingLinks, =
it will fail (column unknown).
If you use the real column name, it works.
Hope this will help
Regards
Marco Menardi

--- In IBObjects@y..., "anthpjc" <anthpjc@y...> wrote:
> Hi,
> (IBO 4.2hg, BCB6(SP2), FB 1.0-796)
> I've also experienced some problems with the OrderingItemNo;
> I've got ordering set for 3 attributes, 2 from the key relation and
> one from a relation selected by a nested select.
> When I've set the ordering item to 1 I've received the ISC Error
> Code: 335544569 'column unknown' on the non-key relation column upon
> which the ordering item is set, then when changing the OrderingItemNo
> to 0 the error is gone but the ordering set on the column is non-
> existent.
>
> anth
>
>
>
> --- In IBObjects@y..., "Miguel" <miguel@i...> wrote:
> > I think that I have found an IBO bug. I am using the last IBO
> version
> > avaliable and FB 1 Release Version.
> >
> > I usually have two indexes, ascend and descent to get that when I
> call Last
> > Dataset procedure and the navegability can be very fast with IBO 4.
> It works
> > very fine but if I call Last procedure and I change the
> OrderingItemNo, my
> > DBGrid (I don't use native controls) begins to do strange things,
> the
> > TDataset becomes empty, if I change the OrderingItemNo again I see
> the
> > TDataset empty again or two or three records, and so on. You can
> test it
> > calling Last and changing the ordering.
> >
> > Jason, has you any idea about this? If I remove the POS parameter in
> > OrderingLinks I haven't any problem.
> >
> > My OrderingItems by example:
> >
> > Código=CNAE;CNAE DESC
> > Descripción=TITULO;TITULO DESC
> >
> > My OrderingLinks:
> >
> > CNAE=ITEM=1;POS=0
> > TITULO=ITEM=2;POS=0
> >
> > If I change this to::
> >
> > CNAE=1
> > TITULO=2
> >
> > My problems go out.
> >
> > My KeyField is ID, an autoincrement field value that I get with a
> generator
> > using GeneratorLinks or IB trigger.
> >
> > Thank you.