Re: Using dynamic order by clause(using Decode) in Forms 4.5

    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