Re: Update Primary Key

Posted in 1998

david.ashby@workcover.nsw.gov.au — Fri, 27 Mar 98 09:52:45 +1000 — source: Informix-list mailing list archive (1991-1998)

Mike, You have to do it manually. If it is not a one of thing you should code a SPL or/and use triggers. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Update Primary Key Author: <morrisma@sterlingdi.com> at WCA-INET Date: 26/3/98 10:47 AM Hello! I have a set of four tables. The first has a primary key and the other three reference that key. How can I modify a primary key value and have that cascaded to all the referencing data? The CASCADE keyword seems to apply only to delete not update. Is there another way? TIA Mike Morris