As Jim mentioned, it's not easily "describable in a place like this" (how much time do you have), however . . .

If you use table buffering on the tables involved in the edit, and if you set the referential integrity up properly, and if you surround the calls to TABLEUPDATE() with BEGIN TRANSACTION and END TRANSACTION, then you'll find that you're not explicitly coding the record locking - VFP handles that for you. I'd suggest looking at the Tasmanian Traders example that comes with VFP. There is actually a lot to be gleaned from that app if you'll take the time to get in and pick it apart.

Russell


>hi all,
>
>i am trying to develop an application in vfp6 to run in a multi-user environment.
>
>do i need to code for file locking / record locking when modifying record, etc. or is it taken care of automatically. if i do have to code can someone give me some sample code for modifying data ?
>
>are there any articles giving guidance as to how to proceed to code for a multi-user environment ?
>
>sincere thanks.