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 09:59:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Error Message when trying to reindex a table in a method
Miscellaneous
Thread ID:
01234687
Message ID:
01234687
Views:
46
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)?
Next
Reply
Map
View

Click here to load this message in the networking platform