OraFAQ Forum: Forms » LOV's decription fail's to increase.

Home » Developer & Programmer » Forms » LOV's decription fail's to increase. (forms 6i , oracle -9i)

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

LOV's decription fail's to increase. [message #283860]

Wed, 28 November 2007 05:37

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

Report message to a moderator

Re: LOV's decription fail's to increase. [message #283866 is a reply to message #283860]

Wed, 28 November 2007 05:42

azamkhan
Messages: 557
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

Report message to a moderator

Re: LOV's decription fail's to increase. [message #283874 is a reply to message #283866]

Wed, 28 November 2007 05:54

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

Report message to a moderator

Re: LOV's decription fail's to increase. [message #283881 is a reply to message #283874]

Wed, 28 November 2007 06:06

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

Report message to a moderator

Re: LOV's decription fail's to increase. [message #283889 is a reply to message #283860]

Wed, 28 November 2007 06:20

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.

Report message to a moderator

Re: LOV's decription fail's to increase. [message #283896 is a reply to message #283889]

Wed, 28 November 2007 06:45

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 19:00:41 CDT 2025