Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Stan.
>1) Why does the alias cause a problem in the first place since it is the correct alias for the table in question?
That's true only if the table is opened with that alias (which it normally is in your code but not necessarily in other code, such as many of the tools that ship with VFP). Code like USE MYTABLE ALIAS SOMEOTHERNAME will fail because the alias on the index expression isn't open.
>Does an alias sometimes get added to a filtered index by VFP?
Not unless you use the VFP Expression Builder, which I suspect is the culprit here. By default, the Expression Builder adds the current alias to the expression (you can turn that option off).
Doug
Précédent
Suivant
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