Para pakar....
Mohon pencerahannya donk....
CREATE OR REPLACE TRIGGER TRIGGER_INSERT_IATA_AIRPORT
AFTER INSERT
ON XODB4.FMM_IATA_AIRPORT
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
INSERT INTO [EMAIL PROTECTED]
(select * from XODB4.FMM_IATA_AIRPORT Where IATA_AIRPORT_CODE =
:new.IATA_AIRPORT_CODE);
END TRIGGER_INSERT_IATA_AIRPORT;
kok trigger ini tidak bisa ya??? tapi jika saya pakai:
INSERT INTO [EMAIL PROTECTED]
VALUES
(:NEW.FLIGHT_NO,:NEW.STAD,:NEW.AFSKEY,:NEW.LEG,:NEW.ATMSATAD,:NEW.STATION1,:NEW.STATION2,
:NEW.STATION3,:NEW.STATION4,:NEW.STATION5,:NEW.STATION6,:NEW.AIRCRAFT_REG_NO,:NEW.REMARK_CODE,
:NEW.TERMINAL_ID,:NEW.GATE_CODE);
itu tidak error....
kenapa ya??
Park yourself in front of a world of choices in alternative vehicles.
Visit the Yahoo! Auto Green Center.
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the
tools to get online.
http://smallbusiness.yahoo.com/webhosting
[Non-text portions of this message have been removed]
