ORM : YARI_ECON
—————-
DECLARE FILL16592 CURSOR FOR
SELECT YARI_ECON.YARM, YARI_ECON.YARS, YARI_ECON.YARI_IDS
FROM YARI_ECON
ORDER BY 1 ASC
KEYS :
——
KEY 1 (U): YARI_IDS
YARI_ECON/INSERT TRIGGER:
————————-
#line 1 YARI_ECON/INSERT
SET TRANSACTION;
INSERT INTO YARI_ECON ( YARM, YARS, YARI_IDS)
VALUES ( :YARI_ECON.YARM, :YARI_ECON.YARS, :YARI_ECON.YARI_IDS);
SELECT 189 INTO :SCREENMSG FROM DUMMY WHERE :RETVAL = 0;
:NEXTPATTERNFLAG = 0;
COMMIT;
YARI_ECON/UPDATE TRIGGER:
————————-
#line 1 YARI_ECON/UPDATE
SET TRANSACTION;
UPDATE YARI_ECON
SET YARM = :YARI_ECON.YARM ,
YARS = :YARI_ECON.YARS ,
YARI_IDS = :YARI_ECON.YARI_IDS
WHERE YARM = :YARI_ECON1.YARM
AND YARS = :YARI_ECON1.YARS
AND YARI_IDS = :YARI_ECON1.YARI_IDS ;
SELECT (:RETVAL = 0 ? 190 : (:RETVAL
