>I'm having a data loss problem. I thought it might be a problem with buffered data not being written to disk for some reason and that Flushing the buffers would solve the problem but it still seems to be happening. Vlad Grynchyshyn suggested turning off the write-behind cache in windows but I 1) am not sure that is the problem and 2) it looks like people here think that that is a last, desperate, system slowing solution. So I'm throwing this out again to see if anyone has any ideas.
>
>The situation is that I am running VFP7 app as a file server on a W98 peer-to-peer network with 4 workstations. I have an updateable view of individuals (vActors_Source) with Optimistic Table Buffering that is supposed to write out to a table (Person). The code below is called after each person is entered. What is happening is that on occasion a user will enter maybe 10 names but when they leave the entering form the names disappear. I tracked down to the fact that the new records are not being updated to the Person table. But I am not getting any TableUpdate Error. Also, something it getting written at one point as the Person_id taken from the Person Table that is Inserted to the Person_Source table is correct but then the record from the Person table somehow disappears.
>
>This has happened on both the workstations and on the computer where the system resides (not running over the network).
>
>Any ideas out there?
Have you tried issuing a TABLEUPDATE() against the base table as well as against the view; I've found that sometimes, a table has gotten opened in a buffered mode before the view ever got opened, and as a result, the table has buffering going, too, requiring its own TABLEUPDATE() to actually commit the data; it's especially frustrating where the underlying table is running in a different buffering mode.