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:
00461871
Views:
23
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)

I use table buffering because anytime you move the record pointer while record buffering, VFP tries to TABLEUPDATE() automatically.

>I am bringing in a large remote view from Oracle. Once I get it, I need to manipulate it a lot and want to index it.
>
>CursorSetProp('buffering',1)
>Makes VFP6/SP4 say "Views require either DB_BUFOPTROW or DB_BUFOPTTABLE"
>
>OK. So then I try to make/take the view offline with
>? CreateOffline('universal_vw','d:\wintemp\universal_vw')
>And I can see a .dbf and .tbf. But I get the same error if I try to index it after that.
>
>How to index a remote view?
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform