Home » Developer & Programmer » Forms » Record Selecting in LOV shows in form
Record Selecting in LOV shows in form [message #463879] Mon, 05 July 2010 01:32 Go to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member
Hi,

I m pretty new in oracle form 6i developement...currently i am learning oracle form 6i itself...i created a form by using wizard...i want to improve that form...

I created one lov which is attached in one of form field..now when i press f9 lov displayed..

But when i select any one record in that LOV , its does not come in my form field


Where is the problem ???

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463901 is a reply to message #463879] Mon, 05 July 2010 02:18 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member
Guys Help me

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463912 is a reply to message #463901] Mon, 05 July 2010 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You probably didn't map LoV values with form items.

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463971 is a reply to message #463912] Mon, 05 July 2010 08:28 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member
no i did it....is there any way to map it...i will send it printscreen ....so get clear idea...

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463980 is a reply to message #463971] Mon, 05 July 2010 09:12 Go to previous messageGo to next message
cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester
Senior Member
No you didn't.

Call up the LOV wizard for your LOV.
Go to the column Display tab.
Set the Return value field to the name of the item you want the value selected to be put in.
You can use the "Look up return item" button iff it helps.

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463984 is a reply to message #463971] Mon, 05 July 2010 09:29 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member
Go to LOV wizard, then column display tab and assign return value. find the attached screen shot.
  • Attachment: lov.JPG
    (Size: 100.82KB, Downloaded 683 times)

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463985 is a reply to message #463984] Mon, 05 July 2010 09:40 Go to previous messageGo to next message
cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester
Senior Member
Isn't that what I just said?

Report message to a moderator

Re: Record Selecting in LOV shows in form [message #463992 is a reply to message #463985] Mon, 05 July 2010 11:55 Go to previous message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member
Thanks You friends.............My problem is solved

Smile

Report message to a moderator

Previous Topic: how send the pic&TEXT in email using PLSQL
Next Topic: ORA-01461 when updating a LONG-Column via trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 30 21:21:05 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.