>>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 &.

Mark,

When I run it through the debugger, the values for the field names are good. I get errors trying to retrieve the data in that particular field.