Re: Forms3.0 Order by

In article <2cipgbs2_at_access.digex.net> mstein_at_access.digex.net (Michael P. Stein) writes:

> In article <AAX9mwi8N1_at_sg2.kbv>, Alex Novicky <oracle_at_vostok.marine.su> wrote:
> >
> >Becky, you can handle user defined dynemic ORDER BY like this:
> >
> >ORDER BY DECODE(:control.flag,'N',name,'A',address,'Z',zipcode,...,code)
 .
> >where :control.flag is a displayed form field in a control block which can
> >be set by user (with some redefined KEY-... trigger), and 'name',
> >'address', 'zipcode', ... and 'code' are sample fields' names in sample
> >table. Note that 'ORDER BY code' is a default ORDER BY.
>
> I don't think this works in 3.0, and I *know* it doesn't work in 2.3
> because I tried it long ago.
> ... deleted ...

Thank you, Michael, I admit your correction. It was wrong to think so without trying to test my suggestion. I used this technique in reports (RPT/RPF Utility). It REALLY WORKS there.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Alex Novicky | New Business Ltd.
Vladivostok  | voice phone (4232)266996         
Russia       | e-mail : oracle_at_vostok.marine.su