Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias not found on database validation
Message
From
05/02/2002 10:40:58
Stan Vaninger
Mitek Industries, Inc
Missouri, United States
 
 
To
04/02/2002 22:25:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00612191
Message ID:
00615501
Views:
24
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform