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 usedcValue=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.