>>? ">" + transform( my_variable ) + "<" >
>
>Recently I had a nasty surprise with this. I had a loop to name the variables to use in a macro (because I had to loop through field1, field2, field3, ..., field45), and I used
>

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.

Dragan,

It's a known fact, that transform has a bug. See this KB artcile for details