Hi all.

I have a strange message on a simple line of code.

On trying to debug it the situation seems even stranger.

I have code:

SELECT 1
USE file1
SELECT 2
USE file2
SELECT 3
USE file3
SELECT 4
USE file4
SELECT 5
USE file5

My program crashes on the USE file5 line with the message "File is in use".

That's stange enough, but if I change the order of the SELECT statements to, for eg, have SELECT 4...USE file4 after SELECT 5...USE file5, then the program crashes on the USE file4 line with the same message.

In either situation a DISP STAT shows me that none of the files are open before I start the SELECT statements.

Does anyone have any ideas?

Secondly, I'm thinking of getting VFP 7 or VFP 8. Are there any known bugs which would suggest the better version to obtain?

And will my existing VFP 6 projects automatically work if I install a later version?

Thanks in advance.

Russell.