CREATE TRIGGER TrGroupdept_update ON groupdept FOR UPDATE AS declare @groupname varchar(30); select @groupname=groupname from inserted; update dormdetail set groupname=@groupname ; 不知上面有什么问题
触发器与delphi程序又冲突。我也遇到过,修改触发器触发的条件。
TO timelyraining(恨天) 怎么修改???
TO songzhiwei(song) 不但加了ID,而且还设了主键都没用!!
CREATE TRIGGER TrGroupdept_update ON groupdept FOR UPDATE AS declare @groupname varchar(30); declare @groupname1 varchar(30); select @groupname=groupname from inserted; select @groupname1=groupname from deleted; if @groupname1<>@groupname update dormdetail set groupname=@groupname ;
FOR UPDATE
AS
declare @groupname varchar(30);
select @groupname=groupname from inserted;
update dormdetail set groupname=@groupname ;
不知上面有什么问题
怎么修改???
不但加了ID,而且还设了主键都没用!!
FOR UPDATE
AS
declare @groupname varchar(30);
declare @groupname1 varchar(30);
select @groupname=groupname from inserted;
select @groupname1=groupname from deleted;
if @groupname1<>@groupname
update dormdetail set groupname=@groupname ;
还是不行呀
错误可能处在Client代码处
贴出部分代码吧
nDateDesignT.Edit;
nDateDesignT.post;