>>I am trying to put a field name in a table, then scan through the table and do a replace but I keep getting the Variable not found error for &rpl. Any Suggestions??
>>
>>SET SAFETY OFF
>>SET STEP ON
>>SELECT LXPOS
>>GOTO TOP
>>SCAN WHILE ! EOF()
>>rpl = ''
>>drpl = ''
>>rpl = ALLTRIM(LXPOS.XDATA) &&The Actual Data
>>drpl = ALLTRIM(LXPOS.XFIELD) && The table and field I am trying to replace
>>REPLACE &drpl WITH &rpl
>>ENDSCAN
>
>
>Replace &drpl. with rpl
>
AFAIK, this can also be done without macro substitution, e.g.:
replace (FieldExpr) with Value
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)