我写的删除触发器如下:并没形成嵌套调用,而且如果把ADOTable换成Table就没有问题,所以我 想不应该是触发器的问题,而是ADOTable的问题,请高手指点 CREATE TRIGGER [UserGroup_DTrig] ON dbo.UserGroup FOR DELETE AS declare @cGroupid varchar(20) select @cGroupid=Groupid from deleted delete from GroupRight where Groupid=@cGroupid
我写的删除触发器如下:并没形成嵌套调用,而且如果把ADOTable换成Table就没有问题,所以我 想不应该是触发器的问题,而是ADOTable的问题,请高手指点 CREATE TRIGGER [UserGroup_DTrig] ON dbo.UserGroup FOR DELETE AS declare @cGroupid varchar(20) select @cGroupid=Groupid from deleted delete from GroupRight where Groupid=@cGroupid
想不应该是触发器的问题,而是ADOTable的问题,请高手指点
CREATE TRIGGER [UserGroup_DTrig] ON dbo.UserGroup
FOR DELETE
AS
declare @cGroupid varchar(20)
select @cGroupid=Groupid from deleted
delete from GroupRight where Groupid=@cGroupid
想不应该是触发器的问题,而是ADOTable的问题,请高手指点
CREATE TRIGGER [UserGroup_DTrig] ON dbo.UserGroup
FOR DELETE
AS
declare @cGroupid varchar(20)
select @cGroupid=Groupid from deleted
delete from GroupRight where Groupid=@cGroupid