Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
EDBManager - altering index |
Tue, Jul 22 2008 6:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Jul 22 2008 12:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 22 2008 1:48 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Jul 22 2008 2:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jul 23 2008 3:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |