Re: Using dynamic order by clause(using Decode) in Forms 4.5
Date: 1998/01/07
Message-ID: <6911j3$c56$1_at_cti15.citenet.net>#1/1
Wouldn't doing somthing like this in the pre-query trigger be simpler?
if var_name = 1 then
set_block_property(name_in('system.trigger_block'), order_by, fld_name1)
else
set_block_property(name_in('system.trigger_block'), order_by, fld_name2)
end if;
Eric Veilleux
eveilleu_at_ers.ca
smitas_at_meghdoot.mastek.com wrote in message
<884088741.43974661_at_dejanews.com>...
>Syntax is
>
>SELECT fld_name1,fld_name2
>FROM table_name
>ORDER BY DECODE(var_name,1,fld_name1,2,fld_name2);
>
>It runs under SQL*PLUS. When we write this code in PL-SQL editor of Forms
>4.5 it doesn't give any compilation error. But at runtime it gives ORA
>error saying Invalid field name.
>
>Please reply soon. It is very urgent.
>
>Thanks.
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Jan 07 1998 - 00:00:00 CET