Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error file is in use
Message
From
21/06/1999 05:10:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error file is in use
Miscellaneous
Thread ID:
00232002
Message ID:
00232002
Views:
36
TOM has 2 views

View "VA" in rowbuffering ;
View "VB" 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 VA
=TABLEUPDATE( .T.,.T.)
SELECT VB
=TABLEUPDATE( .T.,.T.)
End Transaction

Everything go well


Now, TOM and MIKE execute "G" in an environment ( client - servor ) 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 ?
Next
Reply
Map
View

Click here to load this message in the networking platform