Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC, records not ordered
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01579404
Message ID:
01579422
Views:
34
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform