Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need to Index Remote View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00461863
Message ID:
00461871
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform