>Working on an archiving scheme, using Delete triggers to move data to history tables. How can I add my archive funtions on a parent table without the RI Builder overwriting them? Or is it time for another builder that respects my code?
If your Delete trigger looks like this:
ri_MyTable_delete()
change it to:
ri_MyTable_delete() and MyTable_SaveToHistory()
If it is empty, just put your function into the Delete trigger.
In either case, the RI builder will respect that. If the RI function is added, the AND will be added before your function.
On the other hand, alternative RI builders offer additional functions. I use TaxRI, which also creates much more compact, and readable, code. But you don't really need that for your particular problem.
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)
