D
david clark
I am having a problem creating check constraints on
columns involved in foreign key relationships.
The model error checker tells me that both columns
involved in the relationship have to have the same
(exactly the same) range constraints - this is just
untrue..
The help for the error (L3018) says that "Two columns that
are connected by a foreign key relationship must have the
same set of allowable values. If they do not, referential
integrity cannot be guaranteed." which is just garbage, I
can define it in the db with the parent having the check
constraint only, or with the child having stonger
constraints than the parent (like allowing the child only
one of the parent's allowable values)...
Can anyone suggest anything? Otherwise check constraints
is going to be another thing that I have to leave out of
the visio model and add manually...
I feel that visio is a reasonable database modeling tool
with just a few niggling bugs (generation and refresh od
db wise) that need to be sorted out to make it worthwhile
using.
columns involved in foreign key relationships.
The model error checker tells me that both columns
involved in the relationship have to have the same
(exactly the same) range constraints - this is just
untrue..
The help for the error (L3018) says that "Two columns that
are connected by a foreign key relationship must have the
same set of allowable values. If they do not, referential
integrity cannot be guaranteed." which is just garbage, I
can define it in the db with the parent having the check
constraint only, or with the child having stonger
constraints than the parent (like allowing the child only
one of the parent's allowable values)...
Can anyone suggest anything? Otherwise check constraints
is going to be another thing that I have to leave out of
the visio model and add manually...
I feel that visio is a reasonable database modeling tool
with just a few niggling bugs (generation and refresh od
db wise) that need to be sorted out to make it worthwhile
using.