Don't use the VFP INSERT command. Use the SQL INSERT command.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer