Ed et all,

These statements are incorrect. With Row Buffering only the current record is buffered. With Table Buffering the entire table is buffered. On top of this there is another "buffer" (for lack of a better term) of changes for both buffering types. This is what makes functions like GETNEXTMODIFIED(), CURVAL(), OLDVAL, etc. work.

Also, to be devils advocate, nobody's mentioned the use of views and p-views (my favorite approach) instead of buffering the actual tables.

Cheers

>Hmm... Then I just wonder why there are still people around using row buffering. Maybe someone who does it will jump in and clear the issue?
>
>>What Sylvain said. :)
>>
>>>I think that VFP will buffer only the records that were modified since the last TableUpdate()/TableRevert(). Not the complete table. So if you have the habit of clearing the buffer after each row change, the buffer size should not be bigger in table buffering than record buffering.
>>>
>>>>What about of buffer size? It seems to me as strong indication to use row buffering as preferred way (if buffering is used at all).