Bernie, To the best of my knowledge, you end up with a "numbered" table when you have an uncompleted "ALTER TABLE" command or perhaps you aborted the table definition module. When you change a table definition RBase first renames the existing table to a strange all number or an hexidecimal name. It then copies the tables data as changed to the original name.
You may need to run RScope to fix the database or do an unload/reload. You would need to edit the unload file to remove the bad table Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 --- On Mon, 5/4/09, Bernard Lis <[email protected]> wrote: From: Bernard Lis <[email protected]> Subject: [RBASE-L] - Deleting a duplicate table To: "RBASE-L Mailing List" <[email protected]> Date: Monday, May 4, 2009, 12:28 PM I found a numbered table that looks like another table. I renamed it from a number to text I can't delete it because it has a primary key that it says is referenced. The new name does not show up as being referenced. I'd would like to avoid removing the references in other tables (because then I would have to put them all back after the table is deleted). Is there an easier way? Bernie Lis
