General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error file is in use
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
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