>>I am experiancing a very perplexing problem in my code. I try to execute the following line of code.
>>
>> USE Home ALIAS MHome
>>
>>and get ALIAS NOT FOUND three times.
>>
>
>You may be getting bitten by the name HOME - it's a VFP reserved keyword. Try quote encapsulating it, like:
>
>USE ("Home") ALIAS MHome
>
>>This line of and several other similar lines work perfectly.
>>
>> USE Employee ORDER Id ALIAS MEmployee
>>
>>All the files exist in the same dictionary file. If I remove the ALIAS portion of the command it works and in spite of the error message it opens the table and assigns it the correct alias.
>>
>>This is VERY confusing and I can't seem to track it down. I thought it might be a referance to "Home." in an index but I cleaned them all out and it still persists. Validating the database brings up the same error but completes with a Database Valid message.
>>
That was a great idea (and VERRY quick response) but it didn't work in this case. I did fail to state that I am also using StoneField SDT5.1d. I don't think this has anything to do with the problem though.
Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )