The solution is to run a statement before applying the foreign key that checks existing data, then correct the data.
EDIT * FROM <table> WHERE <fkColumn> NOT IN (SELECT <pkColumn> FROM <pkTable>) "Stephen Markson" <[EMAIL PROTECTED]> wrote: >I reported in May 2001 that the foreign key building process did not >check the references to the PK. At the time Razzak replied that it would >be fixed in the next release. Indeed, the "Bug Fix" list at >http://www.rbase2000.com/rbw65pp/MoreBugFixes.htm includes "PK to FK >References (#1630)". (Should that be "FK to PK..."?). However, RBW 1.851 >RT03 still does not check the references. It builds the index and gives >no error message if there is no matching data in the PK table. > >Regards, > >Stephen Markson >ForenSys The Forensic Systems Group >www.ForensicSystemsGroup.com >416 482 2140 > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
