Re: Can I have check and referential constraint on same column?

I have come across a situation where I think I need both a check constraint
and a referential constraint on the same column to handle different
situations.

When a row is inserted the default value for the status column will be 'N'.
When the information has been validated it will change to 'V'. This is my
current check constraint.

If the validation is overridden an override code can be placed into the
status column from an exception table. This is my referential constraint.

I have thought about adding the check values to the exception table and
excluding them from the exception prompt but I would prefer to handle it
without doing that if possible. If I can't have both constraints on the
status column this is probably what I will do.


Rick Chevalier
IT Software Solutions - Loan Servicing



________________________________
Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly
prohibited.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.