Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO - Find field ordinal
Message
From
27/06/2001 10:35:30
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00523996
Message ID:
00524128
Views:
17
Hi John,

The book is ADO Examples and Bets Practices, William R. Vaughn,
Page 310..says:

"rst.fields("chaptitleauthor").value
Referencing a field object by name as shown above is the slowest possible
technique. It can be as much as 6 times slowe then refrencing the field object by
number. It is better to use an ordinal reference like
rst.fields(rst.fields.count-1).´value. This small change multiplied by the number of field object refrences, can make a big difference in overall performance..."

The section was looping through the fields object to bind rows to a grid which I normally would never do by name anyways...

But I see your point. I will just make a few tests but if it turns out to
complicate things I definately will forget I read this..
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform