Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error File is in use .....
Please, excuse me for the inconvenience but I have to resend my message because the system had modified "VB" in "VisualBasic".
Therefore, I rename now "VA" and "VB" in Myview1 and Myview2
*****************************************************
TOM has 2 views
View "MyView1" in rowbuffering ;
View "MyView2" in tablebuffering ;
TOM has modified his 2 views and wants to save them
He executes following group of commands :
( this group is called "G" , later in the explication)
Begin Transaction
SELECT MyView1
=TABLEUPDATE( .T.,.T.)
SELECT MyView2
=TABLEUPDATE( .T.,.T.)
End Transaction
Everything go well
Now, TOM and MIKE execute "G" in an environment ( client - server ) at the same time ;
TOM executes G one second before MIKE
MIKE gets message "108 - File is in use by another user"
If MIKE click on IGNORE, he can later save a second time and everything will succeed
WHY does MIKE get this error ? HOW can MIKE avoid this error ?
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