Hi Elmer,
yes, I agree, but I don't want to cause too much confusion. Actually you can do it even simpler:
USE per IN SELECT('per')
SELECT per
>>Hi Mohammed,
>>
>>as I have told you
MANY times, remember to
ALWAYS include the
AGAIN clause if there is just a little chance that the table is already in use!
USE PER AGAIN>
>Tore,
>
>IF the table to be used is already open in another workarea than the current one, it will be opened in a new workarea with a different alias. That could be a problem if you were expecting it to be a known alias name. At least that is how it works in VFP6. Wouldn't it be better if you are concerned about whether the table is already open us use something like :
>
>
IF !USED("PER")
> USE PER ALIAS PER IN 0
>ENDIF
>SELECT PER