Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I'm singing the non indexing view blues
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00426336
Message ID:
00426342
Views:
23
Scratch that. As Vlad pointed out, you need to have buffering set to 3. I always reverse those :).

>>On one of my views I need an index but the index keeps vanishing after I have created it.
>>
>>It is a small view. I create the view then create the index with
>>
>>INDEX on seq TAG seq
>>
>>This works with no error messages but no index results afterwards.
>>
>>SET ORDER TO TAG SEQ produces no error message.
>>
>>the ORDER() command returns an empty string
>>
>>Using SET to check the data environment does indeed show there is no index on the view.
>>
>>Is a disk presence required before I can create an index? because I notice that the view only appears in memory and not on disk. This might be my problem.
>>
>>If so how do I force a disk presence since it does not appear in the view designer.
>
>You have to set the buffering mode of the view to optimistic buffering with:
>
>CURSORSETPROP("BUFFERING", "view_name", 5)
>
>Then you can create your index. Also, the index only lasts until the view is closed. Next time, you have to recreate it.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform