Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I use a view in a form and allow the user to build an index on the fly.
>Before tableupdateing the record I need to remove the index otherwise VFP complains in the updatetrigger.
>No problem I thought. just set order to 0 and delete tag all and all should be fine. WRONG.
>after that statement the index is still there
>WHAT AM I DOING WRONG??
>
>Peter Cortiel
Not sure... are you sure the view is the currenly selected work area when you do the delete tag all?
BUt, I would go to the original problem... you should be able to update even with an index on the view.... What is the update trigger compalining about? Did you trace the code?
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement