You can put the ordered number for the field in the OrderingItems instead of
the name of the column. Then, in OrderingLinks you put the name of the
column with the reference pos in the OrderingItems.

It should work as long as the server is what is doing the sorting.

Jason Wharton

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Thursday, November 18, 2004 3:56 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Problem with OrderingLinks/Items/etc.
>
>
>
> At 11:42 AM 18/11/2004 +0100, you wrote:
>
>
> >When I click on the grid header (item 3 or 4) I get an error
> -206 with message
> >
> >"Field TX_PROV unknown" (item 3)
> >"Field OWN_PROV unknown" (item 4)
> >
> >What am I missing? Otherwise, the query works fine until I
> click on that
> >columns. The other OrderingItems work fine also.
>
> A query can't be ordered on a derived field, except by degree
> number. I
> don't think OrderingLinks can handle a degree number.
>
> h.
>