-
SQL 7 Triggers
Can anyone tell me if there is a way to provide a update trigger which will update multiple rows in a foreign table.
update table set c1=inserted.c1, c2 =inserted.c2
where c3=inserted.c3
The result that I get is ok when I have a unique entry on c3 but if there is a multiple row set to be updated I get an error 'insufficient or incorrect key column infomation'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|