>Thanks. I am amazed that every time I pose a question, I learn something new! In your code, does the "replace" command actually find each of the 120 "lnMonth" field & records? Thanks again!
Yup, but don't do it for "heavy" processing on each record of large tables.
IF you have to denormalize this way, use arrays, or take the time to create
"handcrafted" replaces for multiple fields in 1 program line if this calculation really is the bottleneck.
HTH
thomas
Précédent
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