Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index problems on views
Message
From
28/05/2004 05:56:01
 
 
To
27/05/2004 18:06:44
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00907626
Message ID:
00908072
Views:
28
>>Hi,
>>
>>I've a project with serveral views. I never had problems with them. Today i work again with these views and everytime when i try to update them i have te following error :
>>
>>'Index does not match the table. Delete the index file and re-create the index'.

Hello.
Here is how i see it.
Table on which your view is based should have a primary/candidate index.
Some field(s) of your view should be marked as primary key column(s) in order for update on your view be functional.
So eather the index of the base table is corrupt or you marked wrong columns of the view as primary key columns.
HTH.
Kamil
A moment of silence is our cosmic reset button.
Previous
Reply
Map
View

Click here to load this message in the networking platform