Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table not closing
Message
From
08/06/2016 18:21:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Table not closing
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01637157
Message ID:
01637157
Views:
129
I have a weird, and persistent problem. A free table that doesn't want to close. Here is code:
IF mwebenable	
	thiswebfile=&mwebpath+'jobsweb.dbf'
	thiswebfile1=&mwebpath+'applweb.dbf'
	USE &thiswebfile1 IN 0
	SELECT applweb
	SET ORDER TO 1 
	IF !USED('&thiswebfile')
		USE &thiswebfile IN 0
	ENDIF 
	SELECT jobsweb
	SET ORDER TO 1
	SEEK mponum
        ....
        ....
	SELECT applweb		
	USE IN applweb
	SELECT jobsweb
	USE IN jobsweb
ENDIF
NO problems with 'applweb.bdf' at all, but run the prg more than once, and 'jobsweb.dbf' comes up unclosed. And I have tried all combos of Select and Use that I can think of.

I can't use 'close tables all', as that will close the stuff in the DE, too, which is NOT wanted.

What else can I do? ANY ideas will be greatly appreciated!

Thanks!
Next
Reply
Map
View

Click here to load this message in the networking platform