Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table updating
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01508749
Message ID:
01508914
Vues:
51
>Thank you, I thought of that before as well, but my navigation grid allows user to click on a header in order to change the order tag on the table for search enhancement. I would have to create a new cursor each time you change the order. Honestly that doesn’t happen very often, but some tables are large and I was concerned with speed degradation.
>
>I will try it again.

You can create indexes on ReadWrite cursors, it usually does not take long.
SELECT * FROM MyTable INTO CURSOR MyCursor READWRITE
*
LOCAL lnFields, lnField, lcFieldName
lnFields = FCOUNT(THIS.AliasName)
*
FOR lnField = 1 TO lnFields
	TRY
		lcFieldName = FIELD(lnField)
		INDEX ON &lcFieldName TAG &lcFieldName ADDITIVE
	CATCH TO loException
	ENDTRY
ENDFOR
Christian Isberner
Software Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform