With the SQL Insert command everything is done in one step, so you don't risk having the problem you describe.

>I'm looking at changing all the scatters..., about 7 in total, to inserts. I know that the scatter, append does not lock the file unless you do your own locking. I'm just wondering if the insert automatically does locking, or is it necessary as the record is inserted as opposed to adding a blank record and then populating it.
>
>~M
>
>>Using the current method takes longer as it's done in two steps. The best option is SQL INSERT.
>>
>>
>>>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