Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement