Forms 3 - Order by in Block Def'n

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1996/04/11
Message-ID: <4ki24r$d5_at_karri.bs.wa.gov.au>#1/1


Situation:
two blocks in Form. block A is a control block. block B is based on a table. according to criteria entered in block A certain rows are returned in block B.
Problem:
 i want to sort the rows in block B so that surnames that exactly match the search criteria in block A are sorted to the front. So i tried: order by decode(surname,:a.surname,1,2)

Oracle complains that there is a right parenthesis missing because it does not like the '.' following the block name. If i am not allowed to use field names (or block names) in the order by, how else can i do this? (i tried using a :global - didnt work either)

pre-thanks

-- 
Steve Corbett.             vvvv
Fremantle Australia.     [ o  o ]    
			    ..     
        ____________oOO____________OOo____________
        |                                        |
        |         stevec_at_fcs.wa.gov.au           |
	|       scorbett_at_perth.dialix.oz.au      |
        |________________________________________|
Received on Thu Apr 11 1996 - 00:00:00 CEST

Original text of this message