Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to Index Remote View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00461863
Message ID:
00461961
Views:
20
Thanks. I needed to set the view to optimistic row buffering (3) and do the index and then set it back to table buffering (5).

I always use table buffering, so it didn't occur to me that I'd have to use row buffering. So I guess there is a use for row buffering. :)


>Views are alwasy optimistically buffered, either RECORD or TABLE. You need record buffering to index:
>
>CURSORSETPROP("BUFFERING", DB_BUFOPTRECORD) && 3
>
>will work.
>
>When working with remote views, I generally:
>
>USE rv_RemoteView NODATA
>INDEX ON Whatever TAG Whatever
>
>CURSORSETPROP("BUFFERING", 5)
Previous
Reply
Map
View

Click here to load this message in the networking platform