Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can a Table Buffered View be index
Message
 
À
06/11/2007 14:27:33
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01267052
Message ID:
01267083
Vues:
17
>>>>>Hi all
>>>>>
>>>>>Can Remote Views with Table Buffering be indexed? The index does not have to be a CDX as it is only for temporary purposes.
>>>>>
>>>>>Please advise.
>>>>
>>>>As Dragan suggested:
>>>>
>>>>*** In INIT event of the form (or anywhere BEFORE you made any changes to the View)
>>>>SELECT YourViewAlias
>>>>CURSORSETPROP([Buffering], 3, [YourViewAlias])
>>>>INDEX ON ..... TAG ...
>>>>CURSORSETPROP([Buffering], 5, [YourViewAlias])
>>>>
>>>
>>>OK, I beat you by 90 seconds - during which you had the time to refresh UT and read my message? Or did you read it later and update yours? :)
>>
>>No, I read your message and then post mine :-)
>
>OK, I'm waiting for a phone call. What's your excuse? :)
>
>>Just as an example to your, for these pepoles (did I need to change this according to thread #1266935 :-)) who didn't know how to change buffering mode.

A beer? (many of it?)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform