Re: Index creation problem

Nils.Myklebust@idg.no (Nils Myklebust) wrote: >Have you realy checked that ther is no such index. I mean run dbschema >or used dbaccess (or was it isql at the time). >If there is no such index you might have run across a bug in a product >so old your only option is to upgrade. >Before you do that you might want to try to dbexport your database, >drop it and import it again just to make sure there is no >inconsistency in the database. Running bcheck or tbcheck first might >also be an idea. Yes, I have confirmed that the index truly does not exist, I have run dbschema on the effected table and I have check sysindexes table. Neither sources believe the index exist. The problem has occured twice now. The first time I dropped the table and recreated it. That fixed the problem, I could then create the new index. It has happened a second time now , however, and I don't want to have to drop the table and recreate it every couple of weeks. Daniel