Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Chris Van de Velde
  Where is Chris Van de Velde?
 antwerpen
 Belgium
 Chris Van de Velde
 To: Russell Hill
  Where is Russell Hill?
 Sydney
 Australia
 Russell Hill
 Tags
Subject: RE: CLOSE DATA
Thread ID: 21859 Message ID: 21869 # Views: 4 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Thursday, April 03, 2003 10:40:38 AM         
   


>
> Hi all.
Maybe a stupid sugestion... are you sure no other application is using the table (.DBF file). To be sure, close all other applications and try again.
>
> 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.
>
>
>
>
>
>
>
>


Chris Van de Velde

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