>Hi all,
>
>I'm trying to use a generic statement to get the value of a specific field in a record by using evaluate(). Each time I try it I get a syntax error. Here's the code I'm using, any ideas??
>
>lcField = 'MyTable.'+field(lnCnt)
>
>lnATAFValue = eval(lcField)
>
>TIA
Hi Perry,
Your code looks OK. Are you sure that lnCnt hasn't got too big, or maybe you start from 0 rather than 1? (I guess you're using a loop bounded by FCOUNT(), do you specify FCOUNT( 'MyTable') when starting the loop, otherwise you may get the number of fields from the currently selected table rather than MyTable.
p.s. Stick with EVAL as it is much faster when looping than &.