Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ordering a tabular in a form
andrewst wrote in news:2896108.1053338303_at_dbforums.com:
> The way to set the order by for a block in Forms is:
>
> set_block_property( 'blockname', order_by, 'itemname1,itemname2' );
>
> So if your block is called 'B' then your code should be:
>
> set_block_property( 'B', order_by, 'city' );
>
> At the moment you are setting it to order a block called 'CITY' by a
> constant value PROPERTY_TRUE, which happens to have the value 4! You
> should therefore get the error:
>
> FRM-41056: Cannot find Block: invalid ID.
Thanks, I've found it. Received on Tue May 20 2003 - 06:34:38 CDT