Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alias not found on database validation
Message
De
05/02/2002 10:40:58
Stan Vaninger
Mitek Industries, Inc
Missouri, États-Unis
 
 
À
04/02/2002 22:25:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00612191
Message ID:
00615501
Vues:
25
Jim,

Thanks for the suggestion. I did find a filtered index on the saTests table that included the table alias in the filter expression:

empty(satests.tes_dreport)

I removed the alias from the filter and that seems to have resolved the problem on the PC that I have been using as a test bed. I no longer get the dialog that wants me to locate the table and the database validates OK. Hopefully, it will have the same effect on the client installation.

I do have a couple of questions if you don't mind.

1) Why does the alias cause a problem in the first place since it is the correct alias for the table in question?

2) Any idea why I have never seen this on my development PC? I am guessing that the alias is not there on the saTests table on my development PC (I will check that this evening). Does an alias sometimes get added to a filtered index by VFP?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform