>Hi
>
>Is it right that you can't issue a REPLACE for the "updating" table in an UPDATE TRIGGER?
>
>If it is right, then that isn't right, or it's not right, why the restriction?
>
>Thanks
>Kev
If you update the same table in the trigger, this would again trigger another update, possibly leading to recursion without end.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)