Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt DBF tables in VFP 6.0
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00416824
Message ID:
00419084
Views:
42
>>Hi Vlad,
>>
>>Seems it is not exactly right. FLUSH sends the command to write the data on disk and data are passed to operating system. At this point the data are saved on disk as far as FoxPro concerned, but they still may be in network buffers/cache somewhere until they are really written to disk.
>>
>
>Hi!
>
> There are certain OS functions that tell it : DO NOT BUFFER THESE DATA, WRITE IMMEDIATELY. That what VFP uses for FLUSH command. This greately increases reliability.

I had a problem with one FoxPro DOS application (not mine). It used commonly approved scheme of getting unique IDs (lock the table, increment value, unlock) When moved to NT network (Token Ring) it started to give duplicate IDs. Using FLUSH didn't affect this behaviour at all. It was tracked down to NT server cache, but it was not possible to turn it off as other app started to fail after that.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform