>In my application I make use of the informtion stored in the foxuser.dbf, and therefore have the command line:
>
> use (sys(2005)) again shared alias (tcCursor)
>
>everything works OK until the user runs two sessions of the application because then I get the error message 'file in use'. How can I open the foxuser.dbf in two intances of the app or detect that the file is already in use?
>
>I tried the following to no avail as for some reason it still generates an error?
>
>tcError = ON("ERROR")
>ON ERROR glError = .T.
>
>*-- Use the resouce file again
>USE (SYS(2005)) AGAIN SHARED ALIAS (lcCursor)
>
>*-- Restore the error handling routine
>ON ERROR &tcError
>
>
>Thanks, Mace
Mace,
You have the problem because the second instance of Fox can't open the Foxuser file. If you look at SET( 'Resource') in the second instance, it should say off. 2 sessions of Fox can't use the same resource file. I'll have a look at detecting the problem in my lowly copy of fox 2.6 for you.
regards
Ian