Home » Developer & Programmer » Forms » Use of "Order by" clause dynamically in LOV on oracle 10g forms (Oracle -forms-10g R2)
Use of "Order by" clause dynamically in LOV on oracle 10g forms [message #406693] Fri, 05 June 2009 07:00 Go to next message
manojbaghel
Messages: 2
Registered: June 2009
Location: Delhi
Junior Member

Hi Guys,

I have a requirement on the use of lov on the forms.

Requirement is like this

1. Create a List Of Values with 2 fields, Code and Description
2. Do not use order by clause in record Group Query
3. Attach this LOV to a field in Form
4. When user invokes the LOV user will see two fields in LOV with header as Code and Description
5. Now when user clicks on Column Header "Code" then LOV should be sorted on Code
6. And if User clicks on Column Header "Description" then LOV should be sorted on Description

If anybody has done like this,please suggest me with examples.

Thanks in advance.

Re: Use of "Order by" clause dynamically in LOV on oracle 10g forms [message #407658 is a reply to message #406693] Thu, 11 June 2009 00:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Create a new form that looks like an LOV and call it from the 'Show_LOV' button.

David
Re: Use of "Order by" clause dynamically in LOV on oracle 10g forms [message #407664 is a reply to message #407658] Thu, 11 June 2009 00:24 Go to previous messageGo to next message
manojbaghel
Messages: 2
Registered: June 2009
Location: Delhi
Junior Member

Hi David,

Thanks for the reply.
But in that case i have to create new form for each and every Lov in the form.
I believe this will be very much tedious and combersome job to use like this in all the forms for all LOVs.

How i can make this one more generic so that we can use it as a standard template for the application?.

Please suggest me with explanation.

Thanks
Manoj
Re: Use of "Order by" clause dynamically in LOV on oracle 10g forms [message #409291 is a reply to message #407664] Mon, 22 June 2009 00:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Place this LOV in an Object Library and then attach and use this OLB in each form.

David
Previous Topic: Password Charateristics to a Text Field
Next Topic: WebUtil Utility does not write to client file
Goto Forum:
  


Current Time: Wed Feb 12 08:57:18 CST 2025