Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table not closing
Message
De
08/06/2016 18:21:17
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Table not closing
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01637157
Message ID:
01637157
Vues:
126
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform