[RBASE-L] - Re: sattach - Razzak's Reply

[A. Razzak Memon]

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.