Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing Views: Table vs Row Buffering
Message
De
02/11/2001 11:32:25
 
 
À
02/11/2001 11:22:27
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00576755
Message ID:
00576770
Vues:
20
This message has been marked as the solution to the initial question of the thread.
>Is it true that views with row buffering can be indexed, but those with table buffering cannot? This is what it seems to me, but I wanted to check first. If so, any reason why? I have a situation where the views had row buffering, but it seemed much more logical for the form's purpose to use table buffering. Now I get an error when setting the index after changing the mode. If this is the case I will have to go back and figure out how to handle all the processes as they relied heavily on having indexes available. Thanks!
>
>Regards, Renoir

Renoir,

You can set the view to row buffering, create the index, and then change it back to table buffering.
cursorsetprop("buffering",3)
index on tableID to viewIndex && create index
cursorsetprop("buffering",5)
HTH,
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform