Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexed Views and Buffering
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00099204
Message ID:
00099208
Views:
18
>>Here's a bit of an annoyance I ran into: I have a view for which I want to change the sort order, so I indexed it on the field it wasn't already ordered by. However, when I hit the save button to take care of my changes, VFP complains about a non-structural index being open, which is apparently a Bad Thing.
>>
>>So, I guess the question is, should I be using this index, and if so, how do I close the index (which is done with INDEX ON dShot TAG dShot)?
>>
>>Thanks. :-)
>
>Try deleting the tag before the view is closed.

Duh -- index on fieldname to index to create an IDX instead. Keep track of the index name then delete it whn no longer needed.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform