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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Thomas Dudziak <[EMAIL PROTECTED]> À : [email protected] 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 <[EMAIL PROTECTED]> 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
