Re: Q: cascaded update

Hi Thomas, I think there is no other way to do it but with triggers. But why the heck do you want to change a primary key? I always thought, primary keyes were not meant to be changed??? Ok, Servus, Roland Thomas 'Dune' Freina wrote: > > Hi there, > > Do you know anything like _cascaded update_ to keep the integrity > of foreign keys when I change the referred (primary) key? > > I am doing this now with triggers and I wonder if there > is no easier (automatic) way in an advanced DB like Informix OnLine. > > Thanks in advance for your hints > -- > Thomas 'Dune' Freina | Horus EDV und Telekom GmbH > email: dune@horus.com | WWW: http://www.horus.com/ > -----------------------+---------------------------- > "We demand rigidly defined areas of doubt and uncertainty." --Vroomfondel