Subject Re: [IBO] "order by coalesce" problem
Author Lester Caine
Matej Golob wrote:

>>Depends how you look at it. Since the order details are now a proper
>>field, they can be used or displayed if required.
>>So is the other way actually needed?
> If I use this "solution", i transfer this "coalesced" field also to
> the client. If I don't need this information on the client, it's just
> wasting of bandwidth between server and client because I transfer
> unneeded information.
> So, solution works, but would be nice, that also "original" query
> works with ibobjects.

Good point - missed that. In most cases I need the 'order' field anyway
but you are right.

Lester Caine
L.S.Caine Electronic Services