There's no reason to use macro substitution in this case
lvFieldName = EVAL(THIS._cAlias + "." + tcFieldName)
In most cases EVALUTAE() function or Name Expression can be used and should be used instead of macro substitution.
>Hi
>
>Presently I have the following statement which stores the value of a table field into a local variable:
>
>lvFieldName = &tcFieldName
>
>I would like to add after the table name to this macro statement, or use the evaluate command. The name of my table is storder in a form propert called _cAlias.
>
>I have tried several combinations, but VFP doesn;t seem to recognize my syntax.
>
>I have tried
>
>lvFieldName=&THIS._cAlias..tcFieldName (VFP doesn't like this one.)
>
>Supposedly , it can also be done with Evaluate() !
>
>Can anyone correct me on the syntax?
--sb--