Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
Duplicate index problem while Optimizing Table |
Fri, Mar 23 2007 11:05 PM | Permanent Link |
"Dominic Willems" | Sorry to bother with an issue concerning an old 3.30 version.
I have tried the archives but came up with very few answers, so I'll try here: I'm having one customer who has a table that just won't optimize. OptimizeTable always throws a "duplicate index" error on some temporary table (numbered name). Have tried the optimize on all the indexes, no difference. Have ran a RepairTable with and without ForceIndexRebuild, no difference. Don't know what I can try next and any clues are welcome. Cheers, Dom |
Mon, Mar 26 2007 9:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dom,
<< I'm having one customer who has a table that just won't optimize. OptimizeTable always throws a "duplicate index" error on some temporary table (numbered name). Have tried the optimize on all the indexes, no difference. Have ran a RepairTable with and without ForceIndexRebuild, no difference. Don't know what I can try next and any clues are welcome. >> If you send me the table as a .zip, I can fix it for you. It's probably something messed up with one of the rows. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 27 2007 8:51 AM | Permanent Link |
"Dominic Willems" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote
> If you send me the table as a .zip, I can fix it for you. It's probably > something messed up with one of the rows. If I send it to you, could you indicate which row, so I can delete it in the active table, or would that not work? The DB is in constant use, and of a very classified nature, but for the latter I'm sure I can count on your discretion? |
Wed, Mar 28 2007 7:56 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dominic,
<< If I send it to you, could you indicate which row, so I can delete it in the active table, or would that not work? >> Sure, that would be fine. Either that, or I can just simply delete it and tell you which one it was. << The DB is in constant use, and of a very classified nature, but for the latter I'm sure I can count on your discretion? >> Absolutely. I don't keep things around here for more than a week anyways because my "support" directory fills up so quickly with test projects, etc. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 28 2007 12:24 PM | Permanent Link |
"Dominic Willems" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote
> Either that, or I can just simply delete it and tell you which one it was. You made me try something out and it worked perfectly! Why didn't you include this simple thing in your RepairTable procedure? tbData.Open; while not tbData.eof do begin try if tbDataTOE.AsString[1] = '0' then // whatever, really. It just needs to crash on reading the record. (it has to return the first digit of a date here. Impossible to be empty.) tbData.Delete else tbData.Next except tbData.Delete end end; tbData.Close; Did the trick. Thanks, Dom |
Thu, Mar 29 2007 6:35 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Dom,
<< You made me try something out and it worked perfectly! Why didn't you include this simple thing in your RepairTable procedure? >> Well, we try to stay away from deleting records automatically unless they absolutely must go, such as is the case with a record that contains a duplicate primary or unique key. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Mar 29 2007 7:47 AM | Permanent Link |
"Dominic Willems" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote
> Well, we try to stay away from deleting records automatically You're right, of course; very wise. |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |