General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Alias is not found error
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only