Re: Dynamic Sorting / SQL*FORMS
From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 20 Jan 93 17:54:54 GMT
Message-ID: <casivils.727552494_at_node_508ba>
Date: 20 Jan 93 17:54:54 GMT
Message-ID: <casivils.727552494_at_node_508ba>
There is an alternate method (but less pretty) way to achieve dynamic sorting. I assume you had a field in the form where the user entered the name of the field to sort by. In the block description, place an order by statement worded something like
ORDER BY DECODE(:FORM.SORT_FIELD_NAME,'FIELD1',FIELD1,
,'FIELD2',FIELD2,
.................
,DEFAULT_SORT_FIELD)
This approach is not as efficient, but should survive the user doing a : search criteria.
Craig Received on Wed Jan 20 1993 - 18:54:54 CET