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.