General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
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