Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo file is invalid
Message
De
06/09/2007 09:30:22
 
 
À
05/09/2007 12:10:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01252452
Message ID:
01252709
Vues:
15
I did further research on the net, and talked to other resources. I finally was able to get the memo file fixed, I think.

I issued this select on each of the memo fields in my table:
select field1, comments1 from table1 where at(chr(0), comments1) > 0 into cursor csrNull nofilter

This showed me where I had corrupt memos and I could delete those memos.
I had 3 bad memos out of 5,400 records.

Then, I issued this command for each memo field in the table:
replace comments1 with null for len(comments1) = 0

After I did that, I was able to successfully pack the table, which (right or wrong) is what I was using for criteria to determine if my table was corrupt or not. It is now able to be packed.

I will be doing more testing today.

I believe the crash of the server was the cause of this corrupted table.

If anyone has additional input, I am interested in knowing.

Thank you for all your assistance.

Laurie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform