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:
00461865
Vues:
24
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform