Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trigger does nothing....created ok procedure ok

Status
Not open for further replies.

Andretix

Programmer
Sep 15, 2003
6
US
I dont know what else to do....everything seems to work.
The trigger created ok and the procedure was ok as well. if i query the DB the systribody table shows the trigger....but when I add records to program....nothing happens

here is the trigger

CREATE TRIGGER licno_trig
INSERT ON aplic
REFERENCING NEW AS new_licno

FOR EACH ROW WHEN(new_licno.apdefnkey = 1043 )
(EXECUTE PROCEDURE licno(new_licno.apkey ));



CREATE PROCEDURE licno (pakey INTEGER)
DEFINE nexno VARCHAR(10);


LET nexno = (SELECT nextval from huff_seq1);

UPDATE cobcoo
SET trcertno = nexno
WHERE apkey = pakey;

UPDATE huff_seq1 SET nextval = nextval + 1;

END PROCEDURE;




NOTHING HAPPENS WHEN THIS IS RUN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top