Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables with Memos getting corrupted
Message
From
20/01/2015 12:47:02
 
 
To
20/01/2015 12:43:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01613967
Message ID:
01613971
Views:
81
>I do a backup and pack each night while everyone is off the system, but one must have exclusive use of the tables to do that.
>
>I do not use the flush command currently. If I understand it correctly it writes to the disk and avoids caching. How does the flush avoid the corruption?

When you Pack, you also include the keyword Memo, I hope?

Personally I have never experienced any corruption at all, so I am only guessing. I have heard other people who have had corruptions didn't have the problem after adding Flush after every command that changes data.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform