General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for the response but I found the problem. In some instances index tags were created that had an alias in the index expression. i.e index on myTable.myfield tag myfield. I had looked everywhere but at the index expressions. This screws up validate database. Thanks again.
>Robert,
>
>Have you tried USE TheDBC.DBC and see what rows there are that reference the problematic tables?
>
>You might also crack open the DBFs in HexEdit and see what the DBC backlink points to.
>
>>I've inherited a database. When running Validate Database I get the message
>>'Alias 'XXXX'is not found' for several tables in the database. I've tried dropping the tables then adding them back to the DBC and I still get the message. Does anyone have any idea where to track down what is causing this. I've looked all over the DBC and I can't see what the problem is.
Previous
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