General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
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