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

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

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
>

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

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
>

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