>>If using a free table I turn on optimistic table buffering and append blank what happens at that point to the table header? I am asking because I want to know if using buffering makes the table more prone to data corruption. Most of my users are on low end peer to peer networks and I seem to be experiencing much more data corruption since moving to VFP.
>
>I didn't notice more data corruption with VFP, than with FoxPro.
>
>Be sure to issue a FLUSH after each TableUpdate() - this will not ensure zero corruption, but I think it helps a lot.
>
>Hilmar.
Hilmar,
There is a bug using buffer mode #3 that leads to table corruption. What you want to use is mode #5, but do your TABLEUPDATE after each row change and set the parameters to treat the rows singlely.
JLK
Nebraska Dept of Revenue