Peter,
If Customer.dbf table is in use with another alias name, use customer would be cause error "File In Use" unless you include AGAIN keyword. Additionally, in a multi-user environment if anyone else has customer.dbf open exclusively, you would get error "File access denied" whether you try to open it exclusively or shared. If another user has it open shared and you try to open it exclusively, you will get error "File access denied".
Also the syntax
if not used('customer.dbf')
would always return .t. since used function is expecting an alias name.
At least that is how it works in VFP6 SP5
Elmer
>So what... Even if there are 1.000 aliases that point to the customer.dbf, the command USE CUSTOMER would not cause an error.
>
>>Evelyn,
>>In addition to Jens' reply keep in mind that the customer.dbf table could be open with a different alias.
>>
>>Einar
>>>
>>>if not used('customer.dbf')
>>> use customer
>>>endif
>>>
>>>
>>>i have the above code in my program. when i do this, i get error
file is in use in line use customer.
>>>
>>>but shouldn't the condition, check if the table is in use? if it is, it should do the use customer.
>>>
>>>pls advise. TIA.