Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ordering a tabular in a form
"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
![]() |
![]() |