• Subject: Re: Referential Integrity with soft deletes
  • From: dhandy@xxxxxxxxxxx (Douglas Handy)
  • Date: Thu, 30 Mar 2000 14:07:36 -0500


>Is there a way to enforce this using RI?

I'd setup a *BEFORE *INSERT trigger to check the state of the master
record, and issue an escape message if not active.  This will disallow
adding any new records which violate the business rule.

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page