AnsweredAssumed Answered

Loop and Replace Field Contents produce different results

Question asked by ultranix on Apr 8, 2014
Latest reply on Apr 8, 2014 by philmodjunk

Title

Loop and Replace Field Contents produce different results

Post


     Hello, I have a database of 25000 records and more than 400 fields. Half of them are calculation, other's indexed fields, in which information from calculation fields is put via replace field contents or loop scripts.

     As replace field contents takes more time to perform on 25000 records, I recently switched to Loop script (which, after some tests, performed faster), where I perform set field scripts, go to next record and exit after last.

     What is bothering me - errors in set field results. For example, if I go to the certain record and compare results of unstored calculation field and indexed field, which result is produced via loop and set field, those results are different.

     How come it be this way? For the calculation fields formulas, I only use indexed fields, i.e. I don't use unstored calculation fields inside my calculation formulas, so I wouldn't believe in explanation that "as the calculation of one field changes, your final result can change". I use "static" data, which is once entered and never re-calculated for my formulas.

Outcomes