这个触发器有问题吗？？？为什么有compilaton 错误，(100分)

A

alei_nb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #1

CREATE TRIGGER TDCFS.AAA
AFTER INSERT
ON TDCFS.LIGHTER_CTN_INFO
begin
insert into t_main(primary_key,work_type) balues('111','1')
end aaa;

 

Y

yanliang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #2

触发器的定义格式：
CREATE TRIGGER TDCFS.AAA
AS INSERT
ON TDCFS.LIGHTER_CTN_INFO
begin
insert into t_main(primary_key,work_type) balues('111','1')
end

好像还没有看见过用AFTER的。

 

X

xshengjue

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #3

CREATE OR REPLACE TRIGGER triggername
(after/before insert or update ...) on tablename
(for each row);

 

高

高小五

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #4

CREATE TRIGGER TDCFS.AAA
AFTER INSERT
ON TDCFS.LIGHTER_CTN_INFO
begin
insert into t_main(primary_key,work_type) values('111','1')
end aaa;