Hi David,

Im believe they are SQL commands running against free tables via ODBC connection in his software. I will have the check with the person and see.

BTW, I did try the requery() function and notice that it only works on the local or remote views and not on a free tables in the DBC(makes sense). With a remote view and table both in browses mode, I issued a =requery('view1') in the VFP7.1 command window and Walla! I updated the table from the view changes.

Questions:
Now, guessing how he is issuing the SQL commands, and suppose there are just free tables in the DBC, what has to take place when I do and rlock() replace.. and unlock for his program to see the changes? Again, I probably have to know how he is issuing the commands in detail in order for me to ensure some update I do will be seen by him, right?