Re: Sorting order in Base Table

Thanks for your reply.
I found my problem is caused by other things!

Van Nieuwenhuyse wrote:

> try select decode(a,'P',1,'S',2,'O',3) aliasname,a,b
> from table_a
> order by 1;
> if you don't need the result of 'aliasname' on the screen, put it on the
> null-canvas.
>
> River heeft geschreven in bericht <36B067C2.4B04FC7E_at_vol.net>...
> >eg. select a,b
> > from table_a
> > order by decode(a,'P',1,'S',2,'O',3)
> >
> >In Forms4.5. How to use base table block to do the above sql?
> >I've tried putting the order by clause at the 'order' property of the
> >block at design time and runtime,
> >but to no avail.
> >
> >Any advice,
> >
> >River
> >novice DBA
> >
> >
Received on Fri Jan 29 1999 - 15:50:19 CET