>Hi all,
>Just need to confirm, will using alter table function fire insert triggers of tables?
>Thanks in advance.
>yau
I think it will fire update trigger, but not insert trigger. But better do some tests.
I do my table updates through an APPEND FROM in an empty copy of the table; this, of course, would fire the Insert trigger.
You can make your trigger functions dependent on a variable:
if type glOmitTriggers = "L" and glOmitTriggers
return
endif
...
...
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)