You're right I don't think that it is a locking thing myself, or at least not entirely. I'm trying to tidy up the code and bring it up to more modern standards, it's 8-10 years old, and rule out as much as possible.
~M
>In VFP9 help, topic named 'Locking Data' explains all the automatic locking
>
>GATHER locks current record
>
>I would suspect something else than a locking issue
>
>>Hi all,
>>
>>I'm having a problem with an application sometimes confusing 2 records in a table. happens about once a week. Anyway I'm going over the code and I use scatter...append blank...gather in some places. I'm wondering if I change this to an insert command does the insert command automatically lock either the table or record while inserting. I'm trying to find out online but nothing explicit is popping up. It is VFP code and a VFP table.
>>
>>~M
Go raibh maith agat
~M