Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 Tags
Subject: RE: Weird error
Thread ID: 21750 Message ID: 21752 # Views: 25 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Tuesday, April 01, 2003 9:10:40 AM         
   


> 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...

COMPLETE THREAD

Weird error Posted by Russell Hill @ 4/1/2003 8:49:16 AM
RE: Weird error Posted by Boudewijn Lutgerink @ 4/1/2003 9:10:40 AM
RE: Weird error Posted by Russell Hill @ 4/1/2003 9:19:14 AM