Anyone remember if A97 append query failure would ever re****t
data breaking validation rule when such was not the case. I have
an old SQL statement - several years old now. I've encountered
a case in which the append fails and the re****ted error is validation
rule.
The table being appended to (tblClusters) has only 1 field with a
validation rule: [MinimumBatchQty], with Byte Field Size property
setting. The validation rule is >0. The field's default value property
at the table level is 2. The SQL does not include a reference to
that field. I put one in there with a fixed value of 3. Query still
failed with same re****ted error.
I've added 3 fields in recent months. But neither of them have
validation rule settings. Only the one field does. Have any of you
ever known A97 to re****t validation rule violation when referential
integrity violation was really the issue? I'm grasping for straws
here. I just don't know where to check.
Sleepless in Anytown.
