各位我在mssql中加了触发器,在管理器中修改数据都没有错误,触发器也正常执行,但delphi对其post的时候却出现:无法为更新定位行。一些值可能已在最后一次读取后已更改!
触发器去了正常,但我又需要触发器!
CREATE TRIGGER [xgyl] ON [dbo].[MPDefine] 这是我的触发器
INSTEAD OF UPDate
AS
declare @ylold varchar(200)
declare @ylnew varchar(200)
declare @cnylold varchar(200)
declare @cnylnew varchar(200)
declare @lb varchar(200)
if update(yl) or update(cname)
begin
select @ylold =yl from deleted
select @cnylold =cname from deleted
select @ylnew=yl from inserted
select @cnylnew=cname from inserted
select @lb=lb from deleted
update ljzb set yl_en=@ylnew,
yl=@cnylnew
where yl_en =@ylold and yl=@cnylold and lb=@lb
update bugtable set yl=@ylnew where yl=@ylold
end
触发器去了正常,但我又需要触发器!
CREATE TRIGGER [xgyl] ON [dbo].[MPDefine] 这是我的触发器
INSTEAD OF UPDate
AS
declare @ylold varchar(200)
declare @ylnew varchar(200)
declare @cnylold varchar(200)
declare @cnylnew varchar(200)
declare @lb varchar(200)
if update(yl) or update(cname)
begin
select @ylold =yl from deleted
select @cnylold =cname from deleted
select @ylnew=yl from inserted
select @cnylnew=cname from inserted
select @lb=lb from deleted
update ljzb set yl_en=@ylnew,
yl=@cnylnew
where yl_en =@ylold and yl=@cnylold and lb=@lb
update bugtable set yl=@ylnew where yl=@ylold
end
解决方案 »
- TbsSkinDBGrid增加水平滚动条和垂直滚动条,水平滚动条怎么没法换皮肤?
- delphi怎么控制USB
- 用delphi实现甘特图
- c/s中客户端的数据如何保证是最新的?
- modem 传输文件,300分给!!!顶顶也有份阿!!
- 简单问题,散分...
- 如何是的stringgrid的某个cell获得焦点
- 急切需要关于ini文件读、写、查等方面的资料。
- 怎样做一个定时备份并自动删除的过期备份的程序,请高手指点!邮箱为[email protected]
- TREEVIEW和DBGRID的问题!
- 如何在TreeView或ListView上显示叠加图标
- 请问怎么做像MSN QQ那样在左边的那个TAB control 那样的控件啊。。弯弯的那种
1.確認你要觸發的表有唯一字段,如果沒有,加個自動增加的int字段。
2.不要用ltBatchOptimistic,雖然啊數據更新正常,但delphi會報錯的。