Thanks Boudewijn.

I have tried the following:

IF NOT USED("&the_meet_run_file")
USE &the_meet_run_file IN 6
ELSE
MESSAGEBOX("used")
ENDIF

The program crashes on the line USE &the_meet_run_file with the error message "File is in use".

Any ideas?

With regards to the DLL, is it usual for this to appear on a DISP STAT?

I can't recall ever having seen it before.

Thanks again.

Russell.







> > Hi all.
> >
> > I am getting a "file is in use" or "file is not open" on a simple line of code.
> >
> > All I'm doing is:
> >
> > SELECT 6
> > USE filename
> >
> > The program crashes on "USE filename" with either of the above two messages.
> >
> > When I do a DISP STAT just before the SELECT 6 command, this file is definitely not open.
> >
> > I have, however, noticed the following at the end of the DISP STAT:
> >
> > Declared DLLs:
> > GetSystemDirectory C:\WINNT\System32\Kernel32.dll
> >
> > I'm not completely confident about what a DLL even is, and I certainly haven't declared any (to my knowledge) in my code.
> >
> > Does anyone have any ideas?
> >
> > Thanks in advance.
> >
> > Russell.
> >
> the DLL is a Dynamic Link Library, a file in the windows system directory (mainly) that contains functions you can declare and call through any devtool, from which VFP is one possibility.
> This, however, has nothing to do with your first Q.
> What could be the case is that the file is open under a different alias.
>
> did you try:
>

> * check to see whether the file is not used yet.
> IF NOT USED("MyFile")
> 	use MyFile in 0
> ENDIF
> 
> * select the file...
> SELECT MyFile
> 

>
> Boudewijn Lutge®ink
> Boudewijn.Lutgerink@foxite.com
> Experience is the knowledge you get immediately AFTER you actually needed it...