| Post Query trigger [message #644266] |
Mon, 02 November 2015 05:18  |
 |
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  |
cookiemonster
Messages: 13963
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
