Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>Hi,
>>
>>>Now in the separate VFP session we try to open tables used in the process. Prior to executing tableupdate we can open and close the table. But once the tableupdate is issued, we're getting "File is in use" error.
>>>
>>>So, is it the right behavior? The changes for that table are already happened through tableupdate, though the transaction is not yet closed.
>>
>>From Help:
>>When you modify records in a database that is part of a transaction, other users on the network do not have access (read or write) to the records until you end the transaction.
>>
>>When other users on the network try to access records you have modified, they must wait until you end your transaction. They receive the message "Record not available ... please wait" until the records become available. Because of this, it is important to keep the length of the transaction to a minimum or conduct the transaction during times when others do not need access.
>>---------------
>>
>>Maybe the "File is in use" error has the same cause?
>>Regards,
>>Viv
>
>That's what I suspect, but the Help then is misleading. Not only the updated records become unavailable, but the whole table is locked. Could you please reproduce it?
>
TABLEUPDATE(.T.) lock the table
>If this is the case, we need to make sure to do imports only when no one is using the system.
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