Re: How do you print out details of the file structure of a database?

Tech-Archive recommends: Fix windows errors by optimizing your registry


BruceM wrote:
I don't know what a CHECK Constraint is

You should CHECK out the Jet 4.0 'new' (circa 1999) features:

http://support.microsoft.com/default.aspx?scid=kb;en-us;275561

"One new feature added to the Jet CREATE TABLE syntax is Check
Constraints. This new SQL grammar allows the user to specify business
rules that can span more than one table..."

Just don't get too excited about the supposed ON UPDATE SET NULL syntax
in the article <g>.

all I know is that the method I
described has worked for me.

The OP mentioned 'Validation check' and I thought I should mention that
the documenter seems to have a (erroneous) hard-coded assumption that a
table will have at most one CHECK constraint.

Jamie.

--

.

Relevant Pages

  • Re: subroutine stack and C machine model
    ... You stated elsewhere that constant expressions are a ... section so presumably you include in "syntax" the constraints whilst ... Rather, I believe that, if you follow the syntax down far ... support such a rigid distinction. ...
    (comp.lang.c)
  • Re: Implicit Declaration
    ... constraint violation or a syntax violation ... The standard certainly treats them differently, putting syntax rules ... places constraints in sections named "Constraints". ...
    (comp.lang.c)
  • Re: subroutine stack and C machine model
    ... You stated elsewhere that constant expressions are a ... section so presumably you include in "syntax" the constraints whilst ... Rather, I believe that, if you follow the syntax down far ... was your canonical non-syntactic distinction. ...
    (comp.lang.c)
  • Re: int pointing to char
    ... I honestly believe that applying semantics to code that has ... >> constraint violations is enough to determine if the code is erroneous ... >the meaning is "code with this syntax, subject to these constraints, ... If the syntax does not match then the ...
    (comp.lang.c)