OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » LOV (form6i,apps 11.5.10)

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

LOV [message #513472]

Mon, 27 June 2011 14:00

rajendaroracle
Messages: 80
Registered: May 2011
Location: India

Member

hi,

how to resolve this error.when i pressed button,LOV is showing with following error message.I have increased size of that field.
Please give me solution to avoid/hide lov when button pressed.
ERROR:
FRM-40831: Truncation occurred: value too long for field.

Report message to a moderator

Re: LOV [message #513478 is a reply to message #513472]

Mon, 27 June 2011 15:11

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

rajendaroracle wrote on Mon, 27 June 2011 15:00

Please give me solution to avoid/hide lov when button pressed.

Removing list_values from when-button-pressed trigger didn't occur to you?

Report message to a moderator

Re: LOV [message #513485 is a reply to message #513478]

Mon, 27 June 2011 15:43

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, perhaps that should have been "how to avoid/hide ERROR" (not LOV). If that's so, either enlarge the item you are putting that large value into, or - in LoV's SELECT statement - take its SUBSTRING so that it fits the item's length.

Report message to a moderator

Previous Topic:	new version for Windows vista or windows 7
Next Topic:	MS WORD PROBLEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 19 09:02:23 CDT 2025