Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error File is in use .....
Message
From
21/06/1999 05:27:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error File is in use .....
Miscellaneous
Thread ID:
00232005
Message ID:
00232005
Views:
32
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 ?
Reply
Map
View

Click here to load this message in the networking platform