Re: Urgent Help ! Forms 4.5 Query

From: todor <todor_at_pi.net>
Date: Thu, 23 Apr 1998 21:07:28 +0200
Message-ID: <6ho3ge$4333_at_reader1.wxs.nl>

It's easy:

order by the way you derive your items:

example:

SQL> select deptno ,decode(deptno,30,1,20,2,40,3,10,4) from dept   2 order by decode(deptno,30,1,20,2,40,3,10,4);    DEPTNO DECODE(DEPTNO,30,1,20,2,40,3,10,4)

--------- ----------------------------------
       30                                  1
       20                                  2
       40                                  3
       10                                  4

SQL> Mohammed Riazuddin heeft geschreven in bericht <353D15F7.6A640DF_at_170systems.com>...
>Hi,
>
>I have master-detail form. In the master block there are about 5 non
>base-table columns which are displayed. None of the base table columns
>are displayed. Now when the query is executed I need to display the
>records ORDER BY the non base-table columns. (The query as such works
>fine but it displays ORDER BY the base-table columns) Is there a way to
>do this.
>
>Thanks
>
>
>
>
>
Received on Thu Apr 23 1998 - 21:07:28 CEST