Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error File is in use .....
Message
De
21/06/1999 05:27:40
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error File is in use .....
Divers
Thread ID:
00232005
Message ID:
00232005
Vues:
33
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
Fil
Voir

Click here to load this message in the networking platform