Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias is not found error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00686402
Message ID:
00686535
Views:
35
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform