General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Err msg index does not match on a view with no index
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
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