Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
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