Re : FK troubles [Was: Not much info with: "Could not parse or write data file"] aka "The Saga continues II "

[Laurent ROCHE <la...@yahoo.com>]

Hi,

That works !
A shame it only works when FK allows NULL value: I had defined the top parents using their own PK value instead of NULL (which is why I assume you require to have NULL value).

 
Cheers,
L@u
The Computing Froggy

----- Message d'origine ----
De : Thomas Dudziak <to...@gmail.com>
À : ddlutils-user@db.apache.org
Envoyé le : Mardi, 9 Janvier 2007, 8h43mn 53s
Objet : Re: FK troubles [Was: Not much info with: "Could not parse or write data file"] aka "The Saga continues II "

On 1/8/07, Laurent ROCHE <la...@yahoo.com> wrote:

> I have a table where the Foreign Key references the table it-self (case of a parent-child schema).
> On most of the rows, the FK references another row but for the top rows/primary ancestors (called them whatever you want) the FK references the row it self.
> DDL-Utils apparently does not know how to manage this ... and no rows are inserted (as the parents are not inserted, no children are).

You're right, DdlUtils did not handle them. I've added code to deal
with them (even when the PK contains identity columns), please update
and test again.

Tom




__________________________________________________
Do You Yahoo!?
En finir avec le spam? Yahoo! Mail vous offre la meilleure protection possible contre les messages non sollicités 
http://mail.yahoo.fr Yahoo! Mail