Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to retrieve records in SQL server and its indexes
Message
De
29/08/2003 07:18:37
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00824489
Message ID:
00824500
Vues:
21
Hi Reygie!

I don't know if VFK8 automate it, I think that no. But one way of minimize the managment is to create one function to encapsulate the SqlExec function and handle index there, in this case you will are centralized the creations of indexes, thus:
Function MySqlExec(tnCon, tcSelect, tcCursor, tsFieldsIndex, tsIndexName)
   =SQLEXEC(tnCon, tcSelect, tcCursor)
   
   If Not Empty(tsFieldsIndex) And not Empty()
     index on &tsFieldsIndex tag &tsIndexName
     set order to &tsIndexName  && It's not necessary
   Endif
   Return something
EndFunc
I hope this help!
P.S.: Sorry my bad english.
Erick
Força Sempre!
Strength Always!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform