Hi.
I think of buffering as being optimistic or pessimistic.

Buffering means that any changes you are making happen in a workspace (buffer) separate from the physical file. But, eventually, you want to write the changes to the physical file--which means that at some point the physical file needs to be locked.

Optimistic means that locking doesn't happen until the very moment you try to write. Pessimistic means that the locking happens as soon as you start editing.

Row locking is just that: just one record at a time is locked. Table buffering means that the whole table is locked. Row and table can be used with either optimistic or pessimistic buffering.

Which one you need may vary at times depending on your application. Could you give us a brief example of a situation you face and we could suggest buffering and tell you why.

HTH


>Hi,
>I am a totally confused on buffer modes in a form. If you could tell when to use which buffering mode, I would appreciate.