Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ordering a tabular in a form

Re: ordering a tabular in a form

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Mon, 19 May 2003 11:16:13 +0200
Message-ID: <1053335275.121784@news.thyssen.com>


"drukqs" <invalid.drukqs_at_NOpandoraSPAM.belgie> schrieb im Newsbeitrag news:Xns937F754013D48invaliddrukqspandora_at_195.130.132.68...
> Daniel Morgan wrote in news:3EC6AB55.11665F12_at_exxesolutions.com:
>
> > So where is the code? What trigger? And how does it relate to the
> > EXECUTE_QUERY for that block?
>
> As I said it's a when-button-pressed trigger. I am just testing this. So I
> have only 1 form with those 2 fields as desribed in my first example. I
> execute the query manually (just testing). And the I get the tabular
> ordered by postal code. Now if I push the button I want it to be sorted by
> city. That's not so hard to understand I think. And it doesn't work here.
I
> only have this piece of code in the trigger.
> set_block_property('city',order_by,property_true)
> So maybe some advice?
> Thx

I think you have to execute the query again *after* you set the order_by property.

hth,
Guido Received on Mon May 19 2003 - 04:16:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US