Re: WebDB and sorted LOV

You need to use a column alias for 1 of the columns eg:

select ename, ename value
from emp
order by ename

HTH
Geoff

Reinhard Asmus wrote:

> Hallo ...,
>
> i built a unsorted LOV with WebDB and it works well.
>
> But I think I cannot built a sorted LOV for instance select ename, ename
> from emp order by ename. I think WebDB cannot work with this syntax.
>
> Have someone a idea.
>
> Thanks ...
>
> --
> ___________________________________________________________
>
> Reinhard Asmus Tel: +49-30-227-51143
> EDV-Organisation Fax: +49-30-227-56169
> Email: asmus_at_spdfrak.de
>
> Fraktion der SPD im Deutschen Bundestag, Unter den Linden 50, 11011
> Berlin
> ____________________________________________________________
Received on Fri Nov 12 1999 - 01:49:53 CET