[RBASE-L] - Ref Integrity Violation?

[Bruce A. Chitiea]

All:

RBG95(64) SU latest

Error message: 
"Constraint Error"
"Cannot UPDATE: value does not exist in fymonth."

Schema:
FYMONTH.fymid (PK) <-->> DEPOSIT.fymid (FK)
fymid is INTEGER

Goal:
Increment all instances of DEPOSIT.fymid by 2.

Command:
UPDATE deposit SET fymid = (fymid +2)

Result:
Crash and burn.
The desired incremented values DO exist in FYMONTH.fymid.


Questions:

1) Is this a referential integrity error?

2) Do I drop the FK relationship, run the UPDATE, then re-establish the
relationship?

Thanks all, again.

Bruce Chitiea
SafeSectors, Inc.
eCondoMetrics
909.238.9012 cell