Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster way to fill Array with ADO recordset
Message
From
27/10/2002 18:50:50
 
 
To
25/10/2002 01:16:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00715267
Message ID:
00715918
Views:
15
Claudio, this last change should not make a difference because FoxPro evaluates the expression following 'TO' only once, not every step of the for loop.

>oops... another one... instead of:
>
>
>FOR lni = 1 TO .oRS1.RecordCount
>
>
>try
>
>
>local lnRecordCount
>lnRecordCount = .oRS1.RecordCount
>
>FOR lni = 1 TO lnRecordCount
>
>
>Doing like this, instead of reading the RecordCount property in every single iteration of the loop (what has the COM overhead), you just read it once, and then just read a memvar in the iteration. That might help.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform