The problem, I think, is that used() doesn't tell you whether the table is used, but whether an alias with that name exists. IOW, the table may be open, but with another alias.
Also, the table may have been opened by another user, or by another data session.
>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)?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
