referential integrity

Posted in 1999

Topics: Triggers, Constraints & Referential Integrity

Thomas Hartmann — Sun, 14 Feb 1999 09:01:21 +0100 — source: Informix-list mailing list archive (1991-1998)

hello all, I have the following problem: I have a table in which two records are represensent one information: First the user can store the first record: Keyfield-1 = not empty Keyfield-2 = must empty Keyfield-3 = must empty On later time the user can store the second record (but the first must be present!) Keyfield-1 = value from first record Keyfield-2 = must be filled Keyfield-3 = must be filled I know two table would be easier, but I'm only the db-admin and I will prevent that the users make mistakes! How can I solve this problem?

↪ replying to Thomas Hartmann

Denis Hung — Mon, 15 Feb 1999 11:34:33 +0400 — source: Informix-list mailing list archive (1991-1998)

Hi: Can't you use Stored Procedures/Triggers? Cheers. Thomas Hartmann wrote: > hello all, > > I have the following problem: > > I have a table in which two records are represensent one information: > > First the user can store the first record: > > Keyfield-1 = not empty > Keyfield-2 = must empty > Keyfield-3 = must empty > > On later time the user can store the second record (but the first must > be present!) > > Keyfield-1 = value from first record > Keyfield-2 = must be filled > Keyfield-3 = must be filled > > I know two table would be easier, but I'm only the db-admin and I will > prevent > that the users make mistakes! > > How can I solve this problem?