Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias is not found error
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Alias is not found error
Miscellaneous
Thread ID:
00686402
Message ID:
00686402
Views:
91
On deleting all the rows in all my tables (for refreshing data), I received the error 'Alias "inv" is not found'. "inv" is in fact a table in my dbc. It appears the error is occurring in the referential integrity triggers for one of the parent tables of "inv". I tried to 'Validate Database' and received the same error, however, the validate command returned with the 'Database container is valid' message.

I removed all the relations to the inv table and re-generated the ri code. I validated the database again with this error not appearing. I then re-established the relations to the inv table and re-generated the ri code and the error returns.

Also, I validate the meta data using Stonefield with no errors.

Is this familiar to anyone? Or, are there any suggestions on how I can debug this? I know the error is somewhere in the triggers but I don't know how to pinpoint it.

Thanks in advance.
Next
Reply
Map
View

Click here to load this message in the networking platform