Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias not found on database validation
Message
From
05/02/2002 11:01:39
 
 
To
05/02/2002 10:40:58
Stan Vaninger
Mitek Industries, Inc
Missouri, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00612191
Message ID:
00615509
Views:
22
This message has been marked as a message which has helped to the initial question of the thread.
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
Map
View

Click here to load this message in the networking platform