Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error Message when trying to reindex a table in a method
Message
De
21/06/2007 09:59:27
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Error Message when trying to reindex a table in a method
Divers
Thread ID:
01234687
Message ID:
01234687
Vues:
45
I have a form to re-index a table If I use the code
IF USED('users')
	USE IN users
ENDIF

USE users IN 0 EXCLUSIVE
SELECT users
I get the error message
File in Use
In the debugger used('user') is .F.. Why does VFP 9 think the file is in use? If I use the code
USE users IN 0 EXCLUSIVE AGAIN 
SELECT users
or
USE users IN 0 EXCLUSIVE AGAIN ALIAS users
SELECT users
I do not get the above error message, but in the code
lnNoTags	= TAGCOUNT('users')

DIMENSION alcTagInfor[lnNoTags,6]

=ATAGINFO(alcTagInfor,'users')

FOR lnCnt = 1 TO lnNoTags
	lcTagNane		= ALLTRIM(alcTagInfor[lnCnt,1])
	lcTagExpression	= ALLTRIM(alcTagInfor[lnCnt,3])
	lcTagOrder 		= ALLTRIM(alcTagInfor[lnCnt,5])
	DELETE TAG &lcTagNane 
	INDEX ON &lcTagExpression TAG &lcTagNane &lcTagOrder 
NEXT
I get the error message
File must be open exclusively
on the "Delete Tag ..." line.

What file is VFP 9 looking at?

Why am I getting these error messages and how do I fix this problem (using Stonefield STD is not an option)?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform