Home » Developer & Programmer » Forms » query from LOV problem (merged) (Forms 10g)
query from LOV problem (merged) [message #488014] Tue, 04 January 2011 03:56 Go to next message
peterdb
Messages: 3
Registered: January 2011
Junior Member
Hi,

I've got a field with an attached LOV that returns a selected emp_id, but it doesn't return any of the associated fields in the datablock (name, address etc).

If I query the emp_id field manually it returns all the data just fine.

Help please!

Report message to a moderator

Re: query from LOV problem (merged) [message #488018 is a reply to message #488014] Tue, 04 January 2011 04:02 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Presumably you need to change the LOV query.

Report message to a moderator

Re: query from LOV problem (merged) [message #488024 is a reply to message #488018] Tue, 04 January 2011 04:17 Go to previous messageGo to next message
peterdb
Messages: 3
Registered: January 2011
Junior Member
Ok, let me explain a little better. I have a form that contains employee information. I want to select from a list of employees that work at a certain office and see their details. I set the form to query, select the emp_id from the LOV and I want to bring up the rest of the employee's details.

Report message to a moderator

Re: query from LOV problem (merged) [message #488028 is a reply to message #488024] Tue, 04 January 2011 04:26 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well if you're in enter-query mode why don't you just execute the query?
That'd be the correct way to do it.

Report message to a moderator

Re: query from LOV problem (merged) [message #488032 is a reply to message #488028] Tue, 04 January 2011 04:40 Go to previous messageGo to next message
peterdb
Messages: 3
Registered: January 2011
Junior Member
Sorry for wasting your time, I've just redone it and it's working now. I'm not sure what the glitch was.

PS I was executing the query, and it wasn't working that's why I posted.

Report message to a moderator

Re: query from LOV problem (merged) [message #488039 is a reply to message #488032] Tue, 04 January 2011 05:16 Go to previous message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
That wasn't at all clear from your posts.
Glad you've sorted it.

Report message to a moderator

Previous Topic: Oracle on mobile
Next Topic: Migration from Oracle Forms 9i to 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 09:25:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.