At 04:13 PM 5/15/01 -0400, Stephen Markson wrote: >RBWin 6.5+ let's you build a FK even if some of the >rows are orphaned. Is that right? It prevents you from >entering an orphan, but if they are there already, then >building or rebuilding the FK does not give an error. In situations like, you should follow those 8 steps described by Bill Downall in his earlier post. I would also recommend to perform complete UNLOAD and then RE-BUILD the database. Using The Glorious R:BASE 2000 (ver 6.5++), to be released on June 15, 2001, performing the same Re-Build procedure, will provide accurate -ERROR- messages, such as: Cannot insert - value does not exist in TableName (2510). For more details: http://www.rbase2000.com/rbw65pp >It's the same in 6.1. That's HISTORY! >Is this the proper behaviour? That is the result of not inspecting all data before retroactively adding constraints to already-populated tables! Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
