Re: SYS_LAYOUTS table - name error

[Alastair Burr]

Sharon, you may have had a dozen answers by now as my posts seem to taking hours, if not days, to get posted back to me at the moment, but you could try this:   Make a backup of the database first!!! then...   Highlight and copy the table name including the strange characters then type at the R:> prompt:   drop table [paste your copied text] [Return]   If - and it's a big if - R:Base doesn't see that as a system table them it might drop it for you. You can then reload the database and a new proper sys_defaults should be created.   Alternatively, backup up the database to a file and then edit the file with Wordpad or Edit, whatever you use, and correct the name. Then restore the database.   eg:   out backup.txt; backup all; out screen [edit backup.txt] rename database db_old run backup.txt   If you desperately need to keep the layouts you have you could backup the data to a file first and then reload them once you have the table name correct:   out layouts.bup; unload data for sys_layouts; out screen [do corrections] run layouts.bup   Hope this helps, Regards, Alastair.   ----- Original Message ----- From: Sharon Lima To: R:Base List Sent: Wednesday, December 04, 2002 11:04 PM Subject: SYS_LAYOUTS table - name error I have a database that has an error in the name of the SYS_LAYOUTS table. Below it a snippet from the capture of the data check. See those extra characters at the end of the table name SYS_LAYOUTS    Examining table SYS_LAYOUTS     ��       Index:         14       Column:        SYS_LAYOUT_NAME       Column:        SYS_LAYOUT_DATA   My question is, how can I fix most easily fix this database?   I the past I have resorted to dumping the data to ASCII files  from the individual tables and then loading the data back into an uncorrupted database, table by table. There must be an easier way. Hope someone can help. Thanks, Sharon Lima