Re: How to insert values?

Me wrote:

> On Sun, 18 May 2003 13:23:38 -0700, Ana C. Dent wrote:
> :The "obvious"(?) solution is to.....
> :
> :DISABLE the primary & foreign keys.
> :Load the data into the tables.
> :ENABLE the primary & foreign keys.
>
> Yes, that is an obvious solution. I infact used an 'obvious solution'
> even when I had problems creating the tables because each one had a
> foreign key!
>
> But is there a 'more correct' or 'elegant' solution to
>
> 1) Creating the tables
> 2) Inserting the values (with foreign and primary keys enabled)
>

Your problem is that you have a closed, circular reference loop. Eliminate one of the Foreign Key sets, think of that entry as the top of the heap, and start inserting from there. If you draw a picture describing your tables including the links between them, you should quickly be able to decide which one(s) to eliminate (or defer or disable) Received on Sun May 18 2003 - 16:44:22 CDT