Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve records in SQL server and its indexes
Message
From
29/08/2003 07:18:37
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00824489
Message ID:
00824500
Views:
20
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform