General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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 ?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only