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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer