Tim

To answer another poster's question I quickly altered an index on one of my tables. I went to alter it back, essentially dropping a column from the end of the index and was greeted by:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #601 The table Contacts is corrupt (Error reading index pages into cache)
---------------------------
OK  
---------------------------



Roy Lambert

Roy,

<< To answer another poster's question I quickly altered an index on one of
my tables. I went to alter it back, essentially dropping a column from the
end of the index and was greeted by: >>

Any further information on what was altered, SQL from the history, etc. ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Any further information on what was altered, SQL from the history, etc. ?

This was the initial alteration - adding _Soundex to the index

ALTER INDEX "ContactName"
ON "Contacts"
("_Surname" COLLATE "ANSI_CI" ASC,"_Forename" COLLATE "ANSI_CI" ASC,"_Soundex" COLLATE "ANSI_CI" ASC)

The next one would have been simply to drop _Soundex from the index.

Things worked after repairing the table (only thought of doing that a bit ago)

Roy Lambert

Roy,

<< Things worked after repairing the table (only thought of doing that a bit
ago) >>

Is there any chance that you may have killed the application while it was
running at any point ?  Also, this is 2.01, correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Is there any chance that you may have killed the application while it was
>running at any point ? Also, this is 2.01, correct ?

No (EDBManager) and yes (according to Help - About).

Roy Lambert