General information
Title:
ADO - Find field ordinal
HI!
I was reading that accessing a field object by ordinal is 400 % faster..
For example:
oRS.fields("name").value
vs
oRS.fields(0).value
Well I can't really use this I have an idea.
I'll save the ordinal value in a class property after the first look up.
So that at least refreshes are faster in code like..
this.value=oRS.fields(this.name).value
The question is if I have a fields object how do I get the ordinal.
I checked all the properties and couldn't find a way to do it...
Except...
FOR i=0 to oRS.fields.count
IF oRS.fields.name="name"
?i
END
ENDFOR
Which can't be faster...
So If I'm unclear. I am looking for a way to return the ordinal position of a field object knowing it's name..
oRS.fields("name").value=oRS.fields(n).value
How can I find n when I know "name"?
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only