Re: Forms 3.0 problem: Sort by non database fields

bhaskar_at_orion.me.uiuc.edu (Bhaskar Manda) wrote:

>hi
 

>i am trying to sort the rows in my Forms 3.0 form.
>any ideas on how to do this?
>thanx.
 

>-- Sivaram Manda

In the default where clause of the block, write something like:

ORDER BY :BLOCK1.FIELD1, :table.column etc.

Note that you can also use functions, e.g., DECODE(:BLOCK1.FIELD1,"A",1,"B",2,3) etc...

Hope this covers it! Received on Thu Jul 11 1996 - 00:00:00 CEST