Home » Developer & Programmer » Forms » Based on LOV Values in the same Canvas
Based on LOV Values in the same Canvas [message #618971] Thu, 17 July 2014 01:09 Go to next message
mist598
Messages: 1059
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
Re: Based on LOV Values in the same Canvas [message #618982 is a reply to message #618971] Thu, 17 July 2014 02:59 Go to previous messageGo to next message
cookiemonster
Messages: 11285
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.
Re: Based on LOV Values in the same Canvas [message #618987 is a reply to message #618982] Thu, 17 July 2014 03:26 Go to previous messageGo to next message
mist598
Messages: 1059
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
Sounds like the LOV needs a where clause.

Yes Thanks cookiemonster.. Smile 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
Re: Based on LOV Values in the same Canvas [message #618988 is a reply to message #618987] Thu, 17 July 2014 03:31 Go to previous messageGo to next message
cookiemonster
Messages: 11285
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?
Re: Based on LOV Values in the same Canvas [message #618990 is a reply to message #618988] Thu, 17 July 2014 03:36 Go to previous messageGo to next message
mist598
Messages: 1059
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

Re: Based on LOV Values in the same Canvas [message #618994 is a reply to message #618990] Thu, 17 July 2014 04:00 Go to previous messageGo to next message
cookiemonster
Messages: 11285
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.
Re: Based on LOV Values in the same Canvas [message #619018 is a reply to message #618994] Thu, 17 July 2014 06:31 Go to previous message
Littlefoot
Messages: 19890
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.
Previous Topic: Reports
Next Topic: Populate / display dynamic columns in Forms
Goto Forum:
  


Current Time: Sat Dec 20 21:28:16 CST 2014

Total time taken to generate the page: 0.05651 seconds