General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem - Error FILE IS IN USE
Hello,
In method LOAD a form (rapportusps), I have the following code:
dodefault()
set deleted on
SET MULTILOCKS ON
use (oapp.cData+"profiles") share in 0
select profiles
When this form calls and that I am with the following line:
use (oapp.cData+"profiles") share in 0
it gives me following error: FILE IS IN USE
1-I checked when it makes the DODEFAULT(), it opens the table PROFILES
(not, it does not open)
2-I have make the program until the form rapportusps (method LOAD) and it opens the table PROFILES when it points the DODEFAULT() of method LOAD of the form rapportusps.
3-but when it arrives at the line uses (oapp.cdata+"profiles") share in 0, it gives me errror following: FILE IS IN USE.
4-I know that I could close the table PROFILES before but I know there is better a way of doing it.
5-Moreover, I believe that the table PROFILES is open in exclusive mode when it gives me this error. (FILE IS IN USE)
Thanks for help
Isabelle L
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