Based on LOV Values in the same Canvas [message #618971] |
Thu, 17 July 2014 01:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
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
|
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 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:09and 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 #618994 is a reply to message #618990] |
Thu, 17 July 2014 04:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
mist598 wrote on Thu, 17 July 2014 09:36post-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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|