Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Error #601 Cannot find index page during retrival from cache |
Wed, Sep 24 2008 2:33 PM | Permanent Link |
"Jianfei Xu" | I try to delete one record from table and get this Error Message
Error #601 .... (Cannot find index page during retrival from cache). I still can insert records or delete other records. I am using the SQL like this: Delete From MyTableName Where xGUID='08091910-3110-3750-F389-000D05044500' How can I fix this and any clue what will cause this. Jianfei |
Wed, Sep 24 2008 3:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jianfei,
<< I try to delete one record from table and get this Error Message Error #601 .... (Cannot find index page during retrival from cache). I still can insert records or delete other records. I am using the SQL like this: Delete From MyTableName Where xGUID='08091910-3110-3750-F389-000D05044500' How can I fix this and any clue what will cause this. >> What version of EDB are you using ? Did you try repairing the table ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 24 2008 6:31 PM | Permanent Link |
"Jianfei Xu" | I try repair table, after repair, it is fine.
UniCode for Dephil 2.01 B5 (Delphi 2007) Jianfei "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:CFB3BE2E-00AF-4FC1-BAAE-9B6F50C9C9C3@news.elevatesoft.com... > Jianfei, > > << I try to delete one record from table and get this Error Message > > Error #601 .... (Cannot find index page during retrival from cache). > > I still can insert records or delete other records. > > I am using the SQL like this: > > Delete From MyTableName Where xGUID='08091910-3110-3750-F389-000D05044500' > > How can I fix this and any clue what will cause this. >> > > What version of EDB are you using ? Did you try repairing the table ? > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Thu, Sep 25 2008 8:49 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jianfei,
<< I try repair table, after repair, it is fine. >> Did you have any improper shutdowns recently, like resetting the application in the IDE or shutting off the computer while it was accessing the database ? -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 25 2008 10:44 AM | Permanent Link |
"Jianfei Xu" | I have no idea, since This is one of user's local DB.
Is there any rules to follow to prevent this happening? Jianfei "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:C5AB42BA-E88F-4EAF-A1C0-979BB5A6D625@news.elevatesoft.com... > Jianfei, > > << I try repair table, after repair, it is fine. >> > > Did you have any improper shutdowns recently, like resetting the > application in the IDE or shutting off the computer while it was accessing > the database ? > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Thu, Sep 25 2008 12:05 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jianfei,
<< I have no idea, since This is one of user's local DB. Is there any rules to follow to prevent this happening? >> You need to look into using the FlushBuffers method to ensure that the OS flushes modified data to disk: http://www.elevatesoft.com/manual?action=mancompmethod&id=edb2&product=d&version=7&comp=TEDBDataSet&method=FlushBuffers http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=9 -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |