Home » Developer & Programmer » Forms » LOV's decription fail's to increase. (forms 6i , oracle -9i)
LOV's decription fail's to increase. [message #283860] Wed, 28 November 2007 05:37 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
hello sir,

i m fail to increase the description's length while i increase the LOV length from 200 to 650.

when i run this record group on toad it shows full description
but while running my form after compling, it does'nt show full data.

please advice me for the further steps. how could i increase it's description.

my queries is.....

SELECT vc_category_code AS nu_category_code,vc_category_description FROM MST_CATEGORY
WHERE vc_comp_code ='01'--:GLOBAL.vc_comp_code
--AND vc_sub_group_code =:mst_item.vc_item_sub_group
--AND vc_group_code =:mst_item.vc_item_group
--AND vc_reason_code =:mst_item.vc_classification
ORDER BY vc_category_description


result is.....

nu_category_code   vc_category_description
000039             KRYPTON (FLATY) LIGHT RASPBERRY 04 50X80 CM SKU 8901147083159


while clicking on lov button it does'nt shows full description.
no effect while increasing lov description fron 200 to 650

Regards

Re: LOV's decription fail's to increase. [message #283866 is a reply to message #283860] Wed, 28 November 2007 05:42 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear there is a property in the LOV property sheet. I cannt remember the exect name of that property. But that property auto adjust the Lov columns. By default it is true or Yes

Set it to False or NO.

Regards,
Azam Khan
Re: LOV's decription fail's to increase. [message #283874 is a reply to message #283866] Wed, 28 November 2007 05:54 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
thanks azamkhan

i will try to find out that property.
if failed to do then come to back.

regards
Re: LOV's decription fail's to increase. [message #283881 is a reply to message #283874] Wed, 28 November 2007 06:06 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
No Dear...
i did that but unable to get my reqd. answer.
by default "automatic column width is set to yes"
i changed it to NO but no change.

can u please tell me any other hints.

Regards
Re: LOV's decription fail's to increase. [message #283889 is a reply to message #283860] Wed, 28 November 2007 06:20 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

Just a couple of thoughts :-

In the LOV property make sure that the LOV is large enough for your fields (width and height).

Then, from the LOV property pallete click on column mapping properties and make sure the field in there for your description is large enough to display the whole thing.

Just check in the record group property pallete -> column specifications that the length for description is long enough (should be anyway).

The combination of the first two should sort out your problem.
Re: LOV's decription fail's to increase. [message #283896 is a reply to message #283889] Wed, 28 November 2007 06:45 Go to previous message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Thanks scorpio_biker

you have solved my problem.
In recode group column specification description size was only
50 that's why it doesn't show full description while increasing lov field size.

now it's working fine

Regards
Previous Topic: Dynamically assign value to an item in a block
Next Topic: Prevent from leaving TEXT_ITEM
Goto Forum:
  


Current Time: Sun Dec 11 02:36:35 CST 2016

Total time taken to generate the page: 0.23442 seconds