Hello,

Found this weird error in a program I sent someone, thought the info might be of use to someone.

The program syntax is -- Use (lcFile32) alias File32.
However, the program give a "alias Crossref is not found message and when you click on OK, the file alias File32 is correctly created. Also tried it from the command line with the same results (used both VFP5.0a and 6.0 sp3):
Use c:\apps_vfp\dbfs\crossref -- OK crossref is part of a database.
Use c:\apps_vfp\dbfs\crossref alias Crossref32 -- I get the message "Alias Crossref is not found" twice. Of course Crossref32 is created.

If I tried to validate the database, I get numerious File Not Found errors, but the database is still "Valid".

I traced it to indexes. Crossref had two indexes, one with a field expression of crossref.doc_id, the other called crossref.ref_id. When you remove the "crossref." part of the index expression all the errors go away!! I don't know how those indexes expressions got built with the table names embedded in them, but I glad there gone.

Kevin