Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC, records not ordered
Message
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 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01579404
Message ID:
01579422
Vues:
35
Yes Borislav, you are right.

Any way to index only cursor upit ?

upit="select * from certificado where exp=0 "


>>While importing, is there a way to index by ID or code at the point below, before fields are added to final DBF ?
>>
>> upit="select * from certificado where exp=0 "
>>IF lnHandle > 0
>> rez=SQLEXEC(lnHandle, upit, "iCert")
>>
>>So there will be no need to index my final table.
>>
>>============================================================================================
>>
>
>Why?
>You never use your final table, aren't you?
>You only use recordsets from it, so better index the incoming record sets instead of the whole table.
>You should use indexes at the backend only when they speed yor queries.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform