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:
00461961
Vues:
21
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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform