Home » Developer & Programmer » Forms » multiple sort options (Forms 6i)
multiple sort options [message #595871] Sun, 15 September 2013 12:10 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

I have a master detail based transaction form, i want to create three check boxes on header block, based on selection sorting must happen on detail block which has three fields, for example there are three fields item_code,item_name,item_qty, if user selects first check box then sorting will be on item_code, if he presses second then sorting should be based on item_name, likewise if he presses check box three then sorting will be based on qty, if choses two or more fields then sorting will according to that combined order.
Re: multiple sort options [message #595874 is a reply to message #595871] Sun, 15 September 2013 13:01 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use SET_BLOCK_PROPERTY in order to apply different sort, utilizing that built-ins ORDER_BY parameter.
Re: multiple sort options [message #595889 is a reply to message #595874] Sun, 15 September 2013 22:44 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks littlefoot , you mean to say change the set_block_property depending upon the when-check-box selection.
Re: multiple sort options [message #595892 is a reply to message #595889] Mon, 16 September 2013 00:07 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not exactly, but close.

You don't change SET_BLOCK_PROPERTY; it is a built-in you use in order to changes block's properties. The rest of your sentence is correct.
Re: multiple sort options [message #595988 is a reply to message #595892] Mon, 16 September 2013 22:58 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks littlefoot, i got it working now.
Previous Topic: Reports in Forms 10g
Next Topic: .gsm file in Forms
Goto Forum:
  


Current Time: Mon Jul 01 10:43:03 CDT 2024