cFieldName="field"+tran(i)where i was the loop counter. To my surprise, when it ran it banged on
cValue=eval(cFieldName)
because the value in cFieldName was Field1.000000000 - probably the loop counter got created with some accidental (?) decimals. Luckily, I knew that the structure of the table will not change and that field1 is the 10th field, so I used cValue=eval(fields(i+9))instead. Still, this accident got me thinking... will tran(integer) always yield a string representation of a number without a decimal point, or is it something to watch out for and code around.