Re: Problem with altering tables

In article <3s6otn$95t@lard.ftp.com> rond@ftp.com "Ron Desjardins" writes: > I am getting the following errors when trying to add a > field to certain tables of my database: > > -211 Cannot read system catalog SYSTABLES > and > -111 ISAM error: no record found > > The errors occur from both dbaccess (table - alter) and > the alter table command. This may also indicate system catalogues which are physically or logically incorrect. I don't know how to do the On-Line equivalent of SE bcheck on them, but it's worth looking for rows in catalogues other than 'systables' which should join to systables & don't e.g SELECT * from syscolumns where tabid not in ( select tabid from systables ) You can do this for all catalogues which contain 'tabid'. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================