Re: Data Constraints AND Application Constraints
From: Paul <paulsnewsgroups_at_hotmail.com>
Date: Thu, 17 Mar 2005 23:34:38 +0000
Message-ID: <qu4k31l57reoiuto159ip8fbo8dbrc9f17_at_4ax.com>
Date: Thu, 17 Mar 2005 23:34:38 +0000
Message-ID: <qu4k31l57reoiuto159ip8fbo8dbrc9f17_at_4ax.com>
"David Cressey" <david.cressey_at_earthlink.net> wrote:
>Both entity integrity and referential integrity should be implement in the
>db and not in the app. Value datatypes, ranges, and omission of manadatory
>values should be checked in both places for values that are not hidden
>inside the app. This is what I've been saying. I think you agree with
>this, and misconstrued my remarks.
My apologies, I did misconstrue what you said - we are in agreement.
Paul...
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, if Oracle group then db := Oracle 9.2.0.1.0; else db := Interbase 6.0.2.0; endif As a courtesy to those who spend time analyzing and attempting to help, please do not top post.Received on Fri Mar 18 2005 - 00:34:38 CET