Home » Developer & Programmer » Forms » How to change width of a column in Oracle Forms at run time (Oracle forms 10g ,Window 7)
How to change width of a column in Oracle Forms at run time [message #631704] Mon, 19 January 2015 00:15 Go to next message
nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida
Junior Member
Hi

I have a request from one of our users to increase width of a column at run time.Can anybody tell me the step,how to implement this function ?

Re: How to change width of a column in Oracle Forms at run time [message #631709 is a reply to message #631704] Mon, 19 January 2015 01:32 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use SET_ITEM_PROPERTY built-in & its WIDTH property.
Re: How to change width of a column in Oracle Forms at run time [message #631726 is a reply to message #631709] Mon, 19 January 2015 03:46 Go to previous messageGo to next message
nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida
Junior Member
Hi Littlefoot


Is there any way to Change column width by user in run time like we did in excel to change A,B,C and other Column Width .


Re: How to change width of a column in Oracle Forms at run time [message #631728 is a reply to message #631726] Mon, 19 January 2015 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Forms is not Excel. As far as I can tell, built-in I already suggested is the only way to do that. I guess that you can create a parameter (block item) which will enable users to set width they are satisfied with. That could be a text item, or a list item with predefined values, or whatever you find appropriate.
Re: How to change width of a column in Oracle Forms at run time [message #631732 is a reply to message #631728] Mon, 19 January 2015 05:08 Go to previous messageGo to next message
nikita.rathore09
Messages: 3
Registered: January 2015
Location: Noida
Junior Member
HI


Please find attached standard form screen shot .In the screen shot I am able to to changed the width of column . I want to implement same function in my custom form.
Re: How to change width of a column in Oracle Forms at run time [message #631736 is a reply to message #631732] Mon, 19 January 2015 05:20 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which tool (name and version) has been used to create that form?

Once again: as far as I can tell, Forms itself can't do it that way. I might be wrong (because I don't know any better), so - wait a little bit longer, someone else might have the answer you are looking for.
Re: How to change width of a column in Oracle Forms at run time [message #631863 is a reply to message #631736] Wed, 21 January 2015 01:08 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Workaround : A push button header

Click the right part ( you do computation on button length) and increase the size
if the left part is clicked then decrease
Re: How to change width of a column in Oracle Forms at run time [message #631973 is a reply to message #631732] Thu, 22 January 2015 08:48 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
nikita.rathore09 wrote on Mon, 19 January 2015 04:08
HI


Please find attached standard form screen shot .In the screen shot I am able to to changed the width of column . I want to implement same function in my custom form.

Your best option would be to open the Oracle supplied EBS form and find the code they use. My guess is that they are using a Java Bean versus a native Forms Widget.

If Oracle has documented how to use this feature, then it will be in the Oracle E-Business Suite Developer's Guide; which can be found in the Oracle EBS Documentation Web Library ( http://www.oracle.com/technetwork/documentation/applications-167706.html ).

Craig...
Previous Topic: import excel Data By column using oracle 6i form
Next Topic: Forms10g : Make Text Item not editable but clickable?
Goto Forum:
  


Current Time: Fri Mar 29 05:04:38 CDT 2024