Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index does not match table recreate index error
Message
From
15/01/2005 04:44:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index does not match table recreate index error
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
00977444
Message ID:
00977444
Views:
124
Hi all,

I have a database container. This dbc contains a connection to a sqldatabase and a set of views on the tables in that sqldatabase.

Everything works well but i have a small problem. When i do a tablerevert(.T.,'tablealias') i have the following error on my screen : index does not match table, recreate index.

Strange because its a view on a sqltable and this table has no index. I tried to validate my database or to recreate the view but the error is comming back. I have this error on other views in my dbc all without a index.

When i ignore the error everything works well.

Can somebody give me some advice ?

Thnx
Reply
Map
View

Click here to load this message in the networking platform