OraFAQ Forum: Forms » Based on LOV Values in the same Canvas

Home » Developer & Programmer » Forms » Based on LOV Values in the same Canvas

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

Based on LOV Values in the same Canvas [message #618971]

Thu, 17 July 2014 01:09

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

I have only one block EMP, and i have 2 LOV columns called PRODUCT,VALUE,deptno

If i select DEPTNO=10 and need to display 10 deptno's employee records

PRODUCT,VALUE,deptno
------- ---- -------
SEARCH 100 10
SEARCH 101 10
SEARCH 111 20

If i select PRODUCT Lov value as SEARCH and click on FIND , ineed to display 3 records

Thanks

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #618982 is a reply to message #618971]

Thu, 17 July 2014 02:59

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

Senior Member

After the number of times I've pointed out that you don't supply enough information about your problems, you really should have learned to think about what information someone who knows nothing about your system needs to answer your question. If you've got a query returning the wrong data (and an LOV is basically a query) then you should always provide the query.

mist598 wrote on Thu, 17 July 2014 07:09

and i have 2 LOV columns called PRODUCT,VALUE,deptno

You say two columns then list three.

mist598 wrote on Thu, 17 July 2014 07:09

If i select PRODUCT Lov value as SEARCH and click on FIND , ineed to display 3 records

Sounds like the LOV needs a where clause.

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #618987 is a reply to message #618982]

Thu, 17 July 2014 03:26

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

Sounds like the LOV needs a where clause.

Yes Thanks cookiemonster.. Smile

And i tried with another way using CTRL+F11 and i have written execute_query in the POST-QUERY at the base table level.It is working fine.

But i moved the same form in the PROD Instance getting FRM:40735:POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION ORA-00904

at the runtime only.

why it is working in the TEST Instance and why it is showing an error?

Thanks

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #618988 is a reply to message #618987]

Thu, 17 July 2014 03:31

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

Senior Member

Have you looked up that error message to see what it is?
Have you worked out which bit of code in the trigger is throwing the error?

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #618990 is a reply to message #618988]

Thu, 17 July 2014 03:36

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

post-query trigger probably contains a 'select' statement that is either returning 'too many rows' or 'no row found'
Quote:

Have you worked out which bit of code in the trigger is throwing the error?

I have only execute_query and this is an existing .fmb file developed by my old seniors and not moved into the PROD Instance.Today i am trying to move into the PROD.

And i have removed the post-query from the Form and now working fine.

It is working fine in the TEST and why the same error where i got in the PROD instance

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #618994 is a reply to message #618990]

Thu, 17 July 2014 04:00

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

Senior Member

mist598 wrote on Thu, 17 July 2014 09:36

post-query trigger probably contains a 'select' statement that is either returning 'too many rows' or 'no row found'

Considering there's an oracle manual listing all the error messages available on the web why are you guessing what the error means?
It is not either of those.

Report message to a moderator

Re: Based on LOV Values in the same Canvas [message #619018 is a reply to message #618994]

Thu, 17 July 2014 06:31

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

Senior Member
Account Moderator

There's one positive thing I see about you, mist598: you are consistent in lying.

mist598

i have written execute_query in the POST-QUERY at the base table level.It is working fine.

EXECUTE_QUERY is a restricted procedure and its usage in POST-QUERY trigger is illegal.

Report message to a moderator

Previous Topic:	Reports
Next Topic:	Populate / display dynamic columns in Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 19:11:37 CST 2025