Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Eliminating memo fields
Message
From
01/06/2008 20:15:56
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01320847
Message ID:
01320860
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform