RE: CLOSE DATA resolved (Posted by Russell Hill) - www.foxite.com

Thanks Lou.

I suspect you're right but I did try:

SELECT 1
USE RAN06549.HOR ALIAS A
SELECT 2
USE RAN06549.RAC ALIAS B
SELECT 3
USE RAN06549.RUN ALIAS C

etc. and still got the error message.

Regards,

Russell.

> >
> > Thanks everyone.
> >
> > I have finally managed to resolve this problem by changing file names.
> >
> > It has been really bizarre to debug but I think the problem was with using non-DBF extensions.
> >
> > In the old days when you had to restrict file names to 8 characters I used to use things like Filename.TRF for a Tax Return File, for example.
> >
> > In that way I had some sort of meaningful handle on what the file was.
> >
> > This new program was an old program re-written in VFP and I was still using .RAC, .HOR, .MTG etc files which are actually data tables.
> >
> > I've never had a problem with this before but for whatever reason I was running up against a brick wall with the "File is in use" message.
> >
> > I eventually considered changing these file names to NewFilenameRAC.dbf, NewFileNameHOR.dbf and NewFileNameMTG.dbf.
> >
> > Amazingly enough this did the trick. Everything now works fine and I don't get any strange messages.
> >
> > One thing I couldn't do though was:
> >
> > USE FileName.RAC
> > COPY TO NewFileNameRAC
> > USE NewFileNameRAC
> >
> > In this case I get the error message "No such file exists .....". However, the following works:
> > USE FileName.RAC
> > COPY TO NewFileNameRAC.DBF
> > USE NewFileNameRAC
> >
> > So I think from now on I'll stick to .DBF file extensions for data tables.
> >
> > Thanks for everyone's help and ideas.
> >
> > Russell.
> >
>
> Just on a curious note: You said that you used different extentions (other than .DBF for the tables before) did, by any chance, the "file4" and "file5" have the same file stem, i.e., file four as TEST.ARC and file five as TEST.QPT ?
>
> What I'm wondering is perhaps the ALIAS's were causing problems. If you want to try a test, try the original file names only specify unique alias's when opening them as in:
>
>

> SELECT 1
> USE TABLE1.ABC ALIAS TABLE1
> 
> SELECT 2
> USE TABLE2.DEF ALIAS TABLE2
> 
> SELECT 3
> USE TABLE3.GHI ALIAS TABLE3
> 
> SELECT 4
> USE TABLE4.JKL ALIAS TABLE4
> 
> SELECT 5
> USE TABLE4.MNO ALIAS TABLE5
> 
> * Did the error occur in this case?
>