Sergey, I'm not clear on exactly what you mean here. If I run an UPDATE-SQL against a table that is not open (or a DELETE-SQL as well), VFP will open it and perform the action that I am requesting. So it is possible that VFP is also performing the USE AGAIN... logic that it employs in SELECT-SQL. One reason it might work this way (or at least conditionally work this way) is that these actions could be wrapped in a BEGIN TRANSACTION...END TRANSACTION construct. In such a case, these actions might have to be rolled back. Actions could then be performed on a working copy of the table until a decision is made to commit the actions.
John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only