在两张表中分别建立两个触发器，第一个表中得触发器是将类型为‘7’的纪录插入到第二
中表中，然后第二张表中的触发器删除第一张表中刚插入的纪录，可是在删除第一张表的
记录是不能成功？!
CREATE OR REPLACE TRIGGER testCardWeed
BEFORE INSERT ON t_consume_record
FOR EACH ROW
WHEN (new.Status = '7')
BEGIN
INSERT INTO t_consume_record_test
VALUES(:new.PackageID, :new.CardIssueID, :new.CardSerialNum, :new.CardType,
:new.MarkTime, :new.TradeTime, :new.CardCounter, :new.TerminalCounter,
:new.TradeType, :new.ChargeIdeal, :new.ChargeActual, :new.Balance,
:new.CompanyID, :new.LineID, :new.DriverID, :new.WatcherID, :new.StationFrom,
:new.StationTo, :new.CollectorID, :new.VehicleID, :new.TeamID, :new.TAC,
:new.Status);
END;

/*************************
CREATE OR REPLACE TRIGGER DeleteTestCard
BEFORE INSERT ON t_consume_record_test
FOR EACH ROW
BEGIN

DELETE FROM t_consume_record
WHERE CardIssueID = :new.CardIssueID AND CardCounter = :new.CardCounter;
END;