FoxPro table error

[psperry2]

I am working on a VFP7 Human Resources system that has passed thru many hands and many versions of FoxPro. When I try to USE the Emp_mast table, this error pops up repeatedly: Alias 'Emp_Hist' is not found.

I click on the ok button repeatedly, then I can finally browse the table. There is no Database that I can find, so I can't understand why I am observing this behavior?

Can anyone offer an Explanation for this?

 

[Dan Freeman]

Check your index expressions. You likely have a tag(s) that references a field in Emp_Hist, or a call to a udf that does so.

 

[Olaf Doschke]

do this

set step on
use emp_mast

and then step through the code and see what happens as you open the table. It may be due to database events - then USE will trigger dbc code - or like dan said through tags (indexes) that use emp_hist or emp_hist(), but I think that won't be triggering such an error due to USE only. From the name it sounds like a history/log table that would get triggered by the open_table dbc event. Or does the error perhaps not happen by using the table but at committing data changes?

Bye, Olaf.

 

[psperry2]

Yes thats what it was, the index expressions, 12 of them, reference fields in the Emp_hist table.