Thanks Razzak, we did the detach all nocheck and it worked great. ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 3:15 PM Subject: [RBASE-L] - Re: sattach - Razzak's Reply
> At 02:55 PM 1/7/2004 -0800, Alan Wolfe wrote: > > >we have a table in a database called 64436or that got there by us > >sattaching a file called 64436or.dbf. > > > >our problem is that we cant remove it now that its attached (it looks like > >the problem is that the table name starts with a number). > > > >does anyone know how to do this? > > > Alan, > > A few options: > > 01. SDETACH ALL NOCHECK > -- if server tables were attached using the SATTACH command > > 0R > > 02. DETACH ALL NOCHECK > -- if attached using the ATTACH command. Used for DBF files. > > OR > > 03. SET NULL -0- > OUTP dbname.ALL > UNLOAD ALL > OUTP SCREEN > -- that will create two files: dbname.ALL and dbname.LOB) > -- keep them together in the same directory) > > DISCONNECT > > RENAME dbname.RB? olddb.RB? > > -- Using the RBG7 Editor (with NO size limit), edit the file > -- and remove all lines related to ATTACH filename, etc ... > > Save the file > > INPUT dbname.ALL > -- that will build a fresh database > > Hope that helps! > > Very Best R:egards, > > Razzak. >
