main logo
Subject: Corrupted table (additionnal info)
Author: Francois Van Lerberghe
Posted: 2002/03/26 16:13:17
 
View Entire Thread
New Search


I wrote :
> =

> Hello Ruslan,
> =

> I have a big problem with this database.
> I cannot add/Modify anything in the table "D%DAtail agenda".
> The last record give me an Error -39.

This was with Valentina PPC 1.8.9r5.
With 1.8.10, trying to access this record, Valentina say "Error 320 :
VarChar corrupted."

> I cannot delete it with Valentina app.
> I cannot export the table.
> Unfortunately, I haven't a backup not corrupted.
> I don't know why and how I have had this corruption.
> I use V4RB 1.8.10 and I'm working with it in Windows 98
> =

> Are you able to fix this.

I have been able to repair the database. But using a very strange way :

As I cannot delete the VarChar field nor do a VCursor.deleteAll, nor do
a Dump, I have done a VCursor.ExportFile to save the data of the
corrupted table.
Next, in Valentina, I have tryed to delete the corrupted table. Choosing
this menu item, Valentina crashed.
Relaunching it with my database, strangely, all tables were there and
the corrupted table was empty.
Then I had imported the previously saved data.

My questions :
1/ Can I safely use the database now.
2/ Have you some idea why this corruption occurs and what I can do or
cannot do to avoid this corruption.
(I always issue a Flush after an Add or Update).

Thank you.

Fran%D9ois Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique
 
©2002 Francois Van Lerberghe
<-- Prior Message New Search Next Message -->