Re: How to temporarily disable referential constraints on a table

"Art S. Kagel" wrote: > > If you REALLY need to disable them then take Byrd's version but if > what you REALLY need is to be able to load complex corellated data > without worrying about the order in which you update the tables, use > Query Gurl's suggestion and DEFER constraint checking until COMMIT > time. > > A note to all: If you post "How do I do such and such a particular > thing" because that is the only way you could think of to solve your > problem you will rarely get the answer you REALLY NEED. Better to > post your problem and let use suggest the best solution(s). Think > how good it will feel when The Clown recommends doing just what you > had decided to do! Is that supposed to be a recommendation? :-O Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+