>Like to have some advise on the best way to handle table maintenance
>in a Network environment.
>1) Having the ControlSource assigned to each field, when doing a ADD
> with APPEND BLANK 'might??' cause problem if another user activated
> the same(ADD function) in a network.
>2) Is it good to use record buffering? Pessimistic or Optimistic?
>3) Is record locking handled automatically by VFP 3.0 when
> APPEND BLANK and REPLACE commands is issued.
> If so, when will it be released(unlocked record)?
>
>Pls advise (I'm quite confused on finding the best way to handle).
>Cheers
>
1. APPEND BLANK shouldn't create abnormal multiuser problems. The bad thing here that users will create too many unnecessary records (if selecting Undo during entry).
2. It entirely depends on app design. If you decided to use buffering, use it everywhere, if not- abstain where possible.
3. Yes, VFP will handle locking automatically. Actually the purpose of explicit locking or buffering is to inform users that someone else working on the same record and handle this case in more sophisticated way.
Edward Pikman
Independent Consultant