Re: Is there a way to conitionaly fire triggers ??

From: hazledid <david.hazledine_at_roche.com>
Date: Fri, 14 May 1999 16:40:34 GMT
Message-ID: <6mY_2.3589$xa.34912@c01read02-admin.service.talkway.com>

Another approach, if the conditional deletion is to be process-driven rather than data-driven (for want of a better word), is to create a parameter table.

This table would contain a permanent/semi-delete flag, the flag's value could be changed at any time, and the triggers would refer to the parameter table to decide whether to copy deleted rows to a mirror table.
This technique is also commonly used to customise the run-time behaviour of other functionality which, like triggers, doesn't provide run-time parameters as such (e.g., views).

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674
Tel. +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Fri May 14 1999 - 11:40:34 CDT