Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 Tags
Subject: CLOSE DATA
Thread ID: 21859 Message ID: 21859 # Views: 47 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Thursday, April 03, 2003 7:05:45 AM         
   



Hi all.

I have a very strange problem which I've spent two days trying to fix without success.

I am getting an error message "File is in use" when the file is patently not in use. A simple DISP STAT shows this.

Nevertheless the program is crashing so I need to fix it.

I have now added a CLOSE DATA statement before opening any tables, so presumably there should be no tables open?

I am not using a DBC database but rather just opening up individual stand-alone tables.

The code reads as follows:

CLOSE DATA
SELECT 1
USE table1
SELECT 2
USE table2
SELECT 3
USE table3
SELECT 4
USE table4
SELECT 5
USE table5

I get the error message "File is in use" on the last line (USE table5).

How can a file be in use when I have issued a CLOSE DATA statement?

Also, if I change the order to:

.............
.............
SELECT 5
USE table5
SELECT 4
USE table4

then the error message pertains to the USE table4 statement and table5 is actually successfully opened.

Has anyone got any ideas?

I'm completely at a loss.

Thanks in advance.

Russell.










COMPLETE THREAD

CLOSE DATA Posted by Russell Hill @ 4/3/2003 7:05:45 AM
RE: CLOSE DATA Posted by Michael Gill @ 4/3/2003 7:51:47 AM
RE: CLOSE DATA Posted by Russell Hill @ 4/3/2003 7:58:20 AM
RE: CLOSE DATA Posted by Jamie Osborn @ 4/3/2003 8:31:20 AM
RE: CLOSE DATA Posted by Chris Van de Velde @ 4/3/2003 10:40:38 AM
RE: CLOSE DATA Posted by Caij Gomez @ 4/3/2003 11:28:29 AM
RE: CLOSE DATA Posted by Michael Gill @ 4/3/2003 5:32:44 PM
RE: CLOSE DATA Posted by Victor Dinculescu @ 4/3/2003 3:49:17 PM
CLOSE DATA resolved Posted by Russell Hill @ 4/4/2003 1:05:21 AM
RE: CLOSE DATA resolved Posted by Lou Harris @ 4/5/2003 2:32:31 AM
RE: CLOSE DATA resolved Posted by Russell Hill @ 4/6/2003 10:38:56 AM