Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make this code faster
Message
From
02/05/2013 13:32:13
 
 
To
02/05/2013 12:17:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01572484
Message ID:
01572512
Views:
46
>Well, I don't know about faster, but it won't work correctly. The record pointer is being moved inside the SCAN (replace can change where the current record is) and not reset. REPLACE is particularly problematic as it actually can change the order of the records and cause some to be processed multiple times and others not at all.

>>Select cuttct
>>Set Order To takano

as long as the index takano is just on the field takano and THAT field does not get updated, order should remain the same, because only dependant on takano and recno() ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform