Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement