Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Message when trying to reindex a table in a method
Message
From
21/06/2007 10:02:51
 
 
To
21/06/2007 09:59:27
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01234687
Message ID:
01234688
Views:
12
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)?
Previous
Reply
Map
View

Click here to load this message in the networking platform