OraFAQ Forum: Forms » LOV issues

Home » Developer & Programmer » Forms » LOV issues (Oracle forms 12c, O/S: Windows 10 pro)

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

LOV issues [message #679101]

Tue, 04 February 2020 20:28

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

I have a form which has 2 LOVs(STUDENT_LOV, COURSE_LOV), one against student id text box and the other against course section id text box.
When I invoke/select a specific student if (by pressing CTRL + L key), and click OK, the selected student is then displayed against it's associated fields( first name, last name).
When I select course section id (by pressing CTRL + L key), then the associated courses that the student has enrolled is displayed and that's how I want. But when I double click any one of the record from that LOV, the LOV closes and does not transfer the selected record onto the respective text boxes.

The query that I am using in Course_LOV:

SELECT E.c_sec_id,
       C.call_id,
       T.term_desc,
       E.GRADE,
       S.s_id
FROM enrollment E, course_section CS, term T, course C, student S
WHERE E.C_SEC_ID= CS.c_sec_id
AND C.course_id = CS.course_id
AND CS.term_id = T.term_id
AND S.s_id = E.S_ID
AND E.s_id = :STUDENT.student_id
ORDER BY E.C_SEC_ID

How do I correct this problem?

Attachment: Annotation 2020-02-04 212442.jpg
(Size: 125.56KB, Downloaded 625 times)

Report message to a moderator

Re: LOV issues [message #679105 is a reply to message #679101]

Wed, 05 February 2020 03:03

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

The thing that controls that is the column mapping properties of the LOV.
Specifically the Return Item - that tells forms which datablock item to put the LOV column value in.
So, have you set that correctly?

Report message to a moderator

Re: LOV issues [message #679109 is a reply to message #679105]

Wed, 05 February 2020 12:15

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

As far as I recall, there is only one data block on the form. So this means only 1 table. However my query is fetching data from multiple tables. It's quite likely that I might have goofed up the Return Item on it.

I will take a look and fix the issue. Once done, I will post my results.

Report message to a moderator

Re: LOV issues [message #679123 is a reply to message #679105]

Fri, 07 February 2020 10:45

buggleboy007
Messages: 282
Registered: November 2010
Location: Canada

Senior Member

cookiemonster wrote on Wed, 05 February 2020 03:03

The thing that controls that is the column mapping properties of the LOV.
Specifically the Return Item - that tells forms which datablock item to put the LOV column value in.
So, have you set that correctly?

Thanks CM. You were absolutely correct about it. I took a look at the column mapping property and mapped it correctly besides removing ' S.s_id' from my query.That fixed the issue.

The LOV now behaves the way it is supposed to Smile

Report message to a moderator

Previous Topic:	Does any one of you have - Oracle 9i Developer by J.A.Palinski
Next Topic:	FRM-92101 oracle.forms.net.ConnectionException: Forms session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 29 08:54:57 CDT 2023