DBACCESS Problem

Posted in 1998

Sadagopan, Sathish — Mon, 27 Jul 1998 17:21:09 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, (1) In a particular table the PK is referenced as a FK by many other tables. So , in dbaccess menu options i navigate as follows Table->Info->Constraints->Reference->Referenced Now, the output comes up and so does the message "Duplicate value for a record with unique key" Why does this message come up ? (2) Also I am not able to delete a row in my parent table , I get the message "692: Key value for constraint (informix.pk_ab_defg) is still being referenced" I have checked in all the tables/columns output from (1) above and found no referencing child rows for that key value. Why is this happening , is it that (1) is showing an incomplete output because of the error message ? Pl. Explain , TIA Sathish Sadagopan