Home » Developer & Programmer » Forms » Post Query trigger
Post Query trigger [message #644266] Mon, 02 November 2015 05:18 Go to next message
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
cookiemonster
Messages: 13917
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.
Previous Topic: the number of quotation
Next Topic: 40357 Invalid string in example record. Query not issued.
Goto Forum:
  


Current Time: Fri Mar 29 03:48:45 CDT 2024