Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Eliminating memo fields
Message
De
01/06/2008 20:15:56
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01320847
Message ID:
01320860
Vues:
17
Memo ARE susceptable to corruption, more so if running on Novell.

It is the way the data is appended to the end of the file if a block boundary is exceeded during an edit, a multiuser environment just complicates things more.

I have seen an edit on record 1 of a DBF in a Novell multiuser environment cause all memo references for the whole file appended to the end of the FPT and all block pointers set to record 1 in the DBF.

We did away with memos years ago. (For text entry only)

>I am considering to eliminate all memo fields and FPT files from
>my data. Instead, I will insert all lines of a FPT field to a record of a new table and then delete the FPT and its memo field.
>
>Do you guys think memo fields can increase the probability of corrupted tables as I think ? Or are memo fields irrelevant to data corruption ?
Regards N Mc Donald
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform