OraFAQ Forum: Forms » LOV EXECUTION

Home » Developer & Programmer » Forms » LOV EXECUTION

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

LOV EXECUTION [message #349338]

Sat, 20 September 2008 07:33

maher534510
Messages: 25
Registered: September 2008
Location: jordan

Junior Member

I HAVE LOV CONTAINS OFFICES ID WHEN I CHOOSE ONE OF OFFICES ID
I WANT TO GIVE ME ALL OF THAT OFFICE DATA
LIKE EXECUTE_QUERY BUT BY OFFICE ID THAT I AM POINT FROM LOV

Report message to a moderator

Re: LOV EXECUTION [message #349359 is a reply to message #349338]

Sat, 20 September 2008 13:06

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

Senior Member
Account Moderator

Would you mind reading the OraFAQ Forum Guide, please? Why do you type the whole message in capital letters? Why don't you use punctuation? It is difficult to read and understand what you are asking when questions are asked that way.

If I understood you correctly, there are two ways to do that: the first one is to include all these columns into the record group's query and create lookup items for all of them so that - when you choose an ID - these values get populated into the appropriate items.

Another way would be to use the WHEN-VALIDATE-ITEM trigger which would use SELECT ... INTO statement and do the job after the ID item gets validated.

Report message to a moderator

Re: LOV EXECUTION [message #349380 is a reply to message #349338]

Sat, 20 September 2008 19:21

maher534510
Messages: 25
Registered: September 2008
Location: jordan

Junior Member

thanks man
but i have three related tables in that form and it's master details and huge number of items it's not practical

Report message to a moderator

Re: LOV EXECUTION [message #349396 is a reply to message #349380]

Sun, 21 September 2008 06:57

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

Senior Member
Account Moderator

Well, would you like me to code it for you?

I didn't create this data model, so - if you don't like the idea of three tables being involved, master-detail relationship and who knows what else, because it appears that you decided to keep certain information for yourself, revealing some of them in every new message you post - quit your job.

Or, find another way to do that, if possible.

Report message to a moderator

Previous Topic:	update column from previous row's column in Form (Merged 3)
Next Topic:	Sql Loader command can be used in Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 16:49:34 CDT 2026