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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement