>Help please
>How can I differeces the pessimistic and optimistic in buffering modes?
>can give some example?
>
>thanks in advance
Kelvin
Essentially: Pessimistic means the record is locked all the time the user has (editing) access to it, until the record pointer is moved on or TableUpdate() or TableRevert() are issued. So, it one user has a record, keeps it for a long time while he eidts it, then other users have no access to it during this time.
Optimistic means the record is locked ONLY when the TableUpdate() is issued, so there's far less chance of the above contention.
On top of this there is Row and Table buffering for both cases. Table buffering locks all records in the table, during either an "optimistic" or "pessimistic" length of time.
See help on BufferMode and BufferModeOverride properties
HTH
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.