A is not locked... b will be opened exclusive when the operation is complete.



>Hi everybody, and thanks for any help you may offer!
>In chapter 17 of MSDN visual studio documentation about Visual Foxpro, Programming for Shared Access, I find a list of Commands that Automatically Lock Records and Tables.
>It lists(among other commands) DELETE-SQL(which locks current record), INSERT-SQL(locks table header), and UPDATE-SQL(locks entire table). How about an SELECT-SQL? Or more to the point the SQL statement: SELECT * FROM tableA INTO TABLE tableB
>What kind of locking in applied to tableA and tableB during the execution of this command?
>Many thanks! Paul C.