VFP 愛用者社區

[raylian]

1. 有sql server表setjg ,字段: partno varchar(25), flowno varchar(10),price numeric(10,2)

2.有sql server表setjg1,字段同上.

3.当修改setjg表中栏位price时触发更新setjg1,为什么只更新到最后一笔资料?


我的触发器代码如下:
USE [edpdbtms]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[trjg] ON [dbo].[setjg]
FOR update
AS

Declare @partno varchar(25)
Declare @flowno varchar(10)
Declare @price numeric(10,2)

BEGIN

--更改
IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
begin

Declare temp_rec Cursor for
select b.partno,b.flowno,b.price,b.remark from deleted b
inner join inserted a on b.partno=a.partno and b.flowno=a.flowno

open temp_rec

Fetch next From temp_rec
into @partno,@flowno,@price,@remark

While @@fetch_status=0
begin
insert INTO setjgrec(partno,flowno,price)
values(@partno,@flowno,@price)
Fetch next From temp_rec
Into @partno,@flowno,@price
end

Close temp_rec
Deallocate temp_rec

end
END

[raylian]

没问题了,是这样,原来是前端只更新了一条记录.