Post Query trigger [message #644266] |
Mon, 02 November 2015 05:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/109c7fb9a8dff9ff5524d13fe29c1c81?s=64&d=mm&r=g) |
s_akbari
Messages: 7 Registered: October 2015 Location: iran
|
Junior Member |
|
|
hi, i'm creating a from that a manufacture should enter his code, then all informations that related on him, show in a table under the code item, i write this code in the post query in block level
begin
select prt_num, title_f
into :master.prt_num, :master.scr_title_f
from admin.biboptt
where issinf_srl = :master.scr_manu_code
and typ = '4'
connect by prior srl = bibopt_srl
start with typ = 2
and issinf_srl =
(select srl from admin.issinft where manu_code = 7691);
end;
but when for testing i enter a manufacture code, the table under code item is empty
|
|
|
Re: Post Query trigger [message #644272 is a reply to message #644266] |
Mon, 02 November 2015 07:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You've got a query that looks like it's supposed to return multiple rows.
You're fetching into items that can only hold one value at a time.
That obviously isn't going to work.
It's not at all clear what you want to happen.
|
|
|