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 10:02:51
 
 
À
21/06/2007 09:59:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01234687
Message ID:
01234688
Vues:
11
Maybe the table is open in another datasession?

>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)?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform