in the trigger for update and insert i have the following cursor
declare crs cursor static local for
SELECT [id] FROM inserted
open crs
fetch next from crs into @.v1
print @.@.fetch_status
while @.@.fetch_status = 0
begin
print @.v1
fetch next from crs into @.v1
end
close crs
deallocate crs
the problem is that the @.@.fetch_status is now always -1 and I'm pretty sure that it worked some time ago and i can't figure what is changed.
any ideas ?
thnx.Why would you want to do this? What's the real trigger look like?
Can you post that code?
A cursor in a trigger would more than likely perform poorly...|||I use cursor in trigger cause i can have inserts/updates from multiple sources and i don't want to break the logic.
code in attach|||fixed.
cursor threshold was 0; changed to -1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment