What I would look for is a [lookup?] table that has data in it. One of these tables might have a Foreign Key Reference to your INV table which would then be invalid since the INV table has no records.
>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.
Mark McCasland
Midlothian, TX USA