Re: relations

From: "Martin A. Marques" <martin@math.unl.edu.ar> > >I'm about to insert data into a database which has some relations between >three tables. > >base1.col2 -> base2.col1 (integers) >base1.col3 -> base3.col1 (integers) > >Now, my question is: when I insert data into the database, how do I >maintane >the relation between the inserts of table base1, base2 and base3? > >More clearer: base1 is the mail table of articles, and in base2 I put re >resumes, and in base3 the whole article. When I'm inserting a new article, >how do I keep the relation? Assuming I read your requirement correctly, http://www.informix.com/answers, you have base1 as master of base2 and base3, in which case http://www.informix.com/answers, you should insert first into base1 http://www.informix.com/answers, then base2 and base3. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

if you have foreign keys set up I have a script at http://www.sofbot.com to list a loading order for constrained tables. it is called ref_load_ord (reference load order) -- --------------------------------------------------------- Steven Hauser email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011 ---------------------------------------------------------