All:
*rbase 9.1(64) 9.1.5.20510
*Win7
*Non-Production Database
R> AUTOCHK
... produces the error message:
-ERROR- A foreign key references a table not known to be referenced. (1242)
[OK]
-ERROR- The number of rows counted was not expected. (1254)
[OK]
The first error appears to result after the creation of a view. A foreign key relation between two base tables is redirected to point to the new view, even though that column is not referenced within the new view. (More testing required.) When this misdirection is corrected by redefining the foreign key in the base table, this error goes away in the next AUTOCHK.
The second error is persistent.
An RScope data check reveals that the row count in system files:
SYS_COMMENTS
SYS_COMPUTED
SYS_CONSTRAINTS
SYS_DEFAULTS
SYS_RULES
... differs from the row count expected by the structure file.
Two questions:
1) How does this happen?
2) What will I lose by running RScope Fix?
TIA
Bruce
