Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Mon, May 12 2008 2:40 PM	Permanent Link
"Jose Eduardo Helminsky"	Tim In my tests I accidentally delete an index file (Table.EDBIdx) and I have realized it has created again when I opened the table ? ElevateDB lookup the catalog and check it every open ? Eduardo
Tue, May 13 2008 3:19 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Jose Its even better than that - delete the three files making up the table and they will be recreated (blank) when you next open that database. Its a benefit of storing the metadata in the catalog rather than the table. Mind you if you blow the catalog away you're really stuffed Roy Lambert [Team Elevate]
Tue, May 13 2008 6:01 AM	Permanent Link
"Jose Eduardo Helminsky"	Roy Thanks Eduardo
Tue, May 13 2008 11:35 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Eduardo, << In my tests I accidentally delete an index file (Table.EDBIdx) and I have realized it has created again when I opened the table ? ElevateDB lookup the catalog and check it every open ? >> Just a quick clarification - the index file will be recreated, but it won't be populated if there are rows in the table. You'll have to use the REPAIR TABLE statement to repair the table in such a case. -- Tim Young Elevate Software www.elevatesoft.com
Tue, May 13 2008 12:09 PM	Permanent Link
"Jose Eduardo Helminsky"	Tim Got it. Eduardo