>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.
>
>Thanks for the help in advance
>
>Terry Hobart