Re: relations
On Wed, 28 Jun 2000, Obnoxio The Clown wrote:
> 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.
This only answers to one of my doubts. Do I have to do the relational
insertion at programing level?
Example:
INSERT INTO base1 VALUES (a,b,c,d,e)
INSERT INTO base2 VALUES (A,B,C)
INSERT INTO base3 VALUES (x,y)
Now, I need b=A and c=x. I have to do this at a programing level?
Thanks, clown!
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Mart'n Marqu's email: martin@math.unl.edu.ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------