OraFAQ Forum: Forms » Will Scrolling affect sort order?????

Home » Developer & Programmer » Forms » Will Scrolling affect sort order?????

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

Will Scrolling affect sort order????? [message #82244]

Tue, 13 May 2003 07:45

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi,
My database block has some 15 rows.I have enabled scrollbar in it.But i have one button also to sort the field.
Now the problem is when i click sort button it sorts the fields correctly.But when i scroll them the sorting order changed.
Please guide me...

Thanks
~V~

Report message to a moderator

Re: Will Scrolling affect sort order????? [message #82264 is a reply to message #82244]

Wed, 14 May 2003 05:23

Maaher
Messages: 7065
Registered: December 2001

Senior Member

The best way to implement this is (IMHO) to change the blocks' ORDER_BY property and to re-execute the query with this renewed ORDER BY. You could use the set_block_property built-in.

MHE

Report message to a moderator

Re: Will Scrolling affect sort order????? [message #82268 is a reply to message #82264]

Wed, 14 May 2003 06:27

Victoria
Messages: 152
Registered: July 2002

Senior Member

Hi ,
I have already used the following code in my sort button.

set_block_property('NON_BILLABLE_USOC',order_by,'NON_BILLABLE_usoc');
do_key('execute_query');
clear_message;

Thanks
~V~

Report message to a moderator

Previous Topic:	Need help with dev2k forms
Next Topic:	Forms 3 application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 12:54:17 CDT 2024