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:
00461865
Views:
23
>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?

Set the buffering to 3 [row]. After indexing, you can set the buffering to table [5].
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform