OraFAQ Forum: Forms » Ordering a Block...Kindly Help.

Home » Developer & Programmer » Forms » Ordering a Block...Kindly Help.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ordering a Block...Kindly Help. [message #81697]

Wed, 12 March 2003 08:53

Muzzammil
Messages: 99
Registered: February 2003

Member

Hi Experts,

I put condition when_new_block_instance

set_block_property('sales', default_where,
(:dtbr_cntr.eeyear)and branch=:dtbr_cntr.br');
execute_query;

I have IDNO, NAME,SALE,YEAR,BRANCH,,,... fields.

It is fetching the records and order by IDNO. But immediately after fetching I want it to be sort by NAME.

I mean the records in the blocks should come order by NAME instead of IDNO.

Thanks,

Report message to a moderator

Re: Ordering a Block...Kindly Help. [message #81699 is a reply to message #81697]

Wed, 12 March 2003 13:15

kim
Messages: 116
Registered: December 2001

Senior Member

hello,
try this:

set_block_property('sales', default_where,
(:dtbr_cntr.eeyear)and branch=:dtbr_cntr.br');
set_block_property('sales',order_by,'name');
execute_query;

Report message to a moderator

Previous Topic:	Tree View and web Based Form
Next Topic:	Application Development

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:57:51 CDT 2024