Hi Set,

It's a calculated field defined on the client side, not included in
the SELECT.

Best regards,
Nico

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, October 25, 2002 3:35 PM
Subject: Re: [IBO] IB_Grid Sorting


> At 23:16 25.10.2002 +1000, you wrote:
> > > Is it possible to define a OrderingItems / OrderingLinks for a
> > > calculated field ?
> >
> >No.
> >
> >All sorting of datasets in IBO comes from the server, the server
> >does not know about calculated fields and so cannot provide sorting.
> >
> >Jason once discussed the idea of implementing client based sorting
> >but that has not happened AFAIK.
>
> I read Nicos question to be more like how to set up OrderingItems /
> OrderingLinks for a query like
>
> SELECT A, (A || B) as C
> FROM ATABLE
> ORDER BY 2
>
> and didn't answer because I hadn't done this myself. But this must surely
> be possible?
>
> Set
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>