Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index tag is corrupted starts to occur month ago
Message
De
19/08/2013 05:34:10
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
19/08/2013 04:08:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01580698
Message ID:
01580752
Vues:
53
>>You can create a temp dbc and then in step 1 "copy ... to {tablename} database {temp dbc}", so step 3 becomes unnecessary and you don't lose long field names.
>
>I dont use dbc and long names.
>
>This maintenande program also fixes dbf and fpt corruption if original dbf
>cannot opened and recovers data from dbf/fpt as much as possible using low level read and write.
>Code from Les Pinter book is used for this.
>
>This code works only with fox2x dbf files. If switching to new table stucture,
>this repairing routine stops working: if founds that table is not dbf file and creates
>new empty file destroying all data in all tables.
>I dont have code which can repair/fix dbc/vfp dbf files automatically like
>Pinter routine does for fox2 files.

I wrote something of the kind long ago, but it needs to know the table structure in advance, i.e. it's generated code, so it can do its thing even when table header is overwritten. It was up to date with table structures as of VFP6 or so - so it's not handling nulls, variable length types, blobs and autoincrement fields. Also not sure if it handled memos when blocksize was zero.

Though I could have written those as well, never did because I didn't need to (was in the US at the time and the SMB2 bug wasn't invented yet).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform