Steve,
You are definitely not using the CURRENT version of R:BASE, i.e. R:BASE 2000 (ver 6.5++), Build:1.842xRT03 or higher. With the help of Harlan B. Haynie (Authorized R:BASE Developer), who reported this very old and nasty bug on R:DCC, along with supporting samples and step-by-step instructions to replicate that bug was FIXED on June 6, 2001. The Glorious R:BASE 2000 (ver 6.5++) for Windows and The R:edoubtable R:BASE 2000 (ver 6.5++) for DOS, Build:1.842 were released on June 15, 2001, almost five months ago. All Enhancements, New Commands and Bug-Fixes included in 6.5++ are very clearly documented in RBW65PP.TXT (shipped with the product) and online at http://www.rbase.com/rbw65pp Enjoy the hard work of our R:Team and the countless efforts of dedicated R:BASE Developers/Users to bring the BEST of R:BASE! Very Best Regards, Razzak. P.S. The upcoming inline patch-1 for 6.5++ (.. almost ver 6.6 ..), currently under beta, includes even more enhancements, new commands and very old bug fixes. At 05:40 PM 11/3/01 -0600, Stephen R. Hartmann wrote: >Several times when I have removed Foreign Keys from multiple >tables that reference the same Primary Key the references >flag on SYS_INDEXES stays set. Once this happens the no rows >can be deleted from the table with the Primary Key and the >table can not be dropped. This cannot be repaired with >R:Scope. After this happens the DB has become corrupted. >The only solution has been a complete reload of the data base. >The last time, the unload would not completely execute. > >I am deleting the keys using the menus not SQL commands. Has >anyone had this problem. Is there a more effective way to make >sure the refernce flag is cleared or is there a simpler way to >clear this up once it happens. ===================================-============================ 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. ==================================-=============================
