Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
English
Error: non-structural index open
Message
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Miscellaneous
ID da thread:
00323543
ID da mensagem:
00323947
Views:
19
>I have a local view as part of the database container that is edited by the user in a grid on a form. When the user opens the form, the view is selected and requeried. If the user makes a change, closes the form, immediately re-opens the form, makes another change, and then tries to move to another line or close the form, the error message:
>
>Table MyView has non-structural indexes open
>
>When the form is opened, three indexes are created using:
>
>INDEX ON field1 TAG index1
>
>Is this causing the error? I did not think this command created a non-structural index.
>
>Any ideas how I can clean things up to prevent the above error from occurring?

Rodney,

I guess I saw that once. You might be indexing your view more than once.
Try this:
IF EMPTY( TAG(1))
INDEX ON... TAG...
ENDIF

And so on.

José
Previous
Next
Responder
Mapa
View

Click here to load this message in the networking platform