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,
|
|
|
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;
|
|
|