>I'm still trying to grasp this concept ...
>
>If I set the buffermode to Optimistic Row buffering, and I move the record pointer with a SCAN, am I correct in saying that the table will get updated even if I don't have a TABLEUPDATE command.
Yes
>
>If I set the buffermode to Optimistic Table buffering, then does moving the record pointer with a SCAN update the table for each row?
No
>
>And if I never move the record pointer, does closing the file also update the table?
My tests show that in Row Buffering mode closing the file updates teh table and in Table Buffereing it does not.
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