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
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