OraFAQ Forum: Forms » ORDER BY property

Home » Developer & Programmer » Forms » ORDER BY property

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

ORDER BY property [message #79680]

Tue, 02 July 2002 12:39

Eric Bender
Messages: 9
Registered: June 2002

Junior Member

Is there any way to set a block's ORDER BY property to be dynamic? As in if I had a drop down box somewhere and those were the things that would sort the data block by, how would I do this? Thanks!

Report message to a moderator

Re: ORDER BY property [message #79685 is a reply to message #79680]

Tue, 02 July 2002 22:15

Ravi
Messages: 251
Registered: June 1998

Senior Member

use this statement

set_block_property('BLOCK NAME',order_by,'coloumn name')

But after changing the order by property like thsi you have to re-query the block.

go_block('block name');
execute_query;

let me know if this answers your question

Report message to a moderator

Re: ORDER BY property [message #79699 is a reply to message #79680]

Wed, 03 July 2002 05:46

Eric
Messages: 78
Registered: April 1999

Member

Thanks a lot, thats exactly what I wanted.

Report message to a moderator

Previous Topic:	[Subhash]how insert values by one buttonby adding them in T-list with diffrent button.
Next Topic:	how to check the Enter key is pressed on a Text Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 09:24:16 CST 2025