> > I wouldn't give the & such a high praise, not anymore. It worked great in FPD and early versions of VFP, but lately I switched to using ( ) instead. For instance, you need to append certain records from some table to the currently selected one:
>
> Unfortunately the EVAL() function (which is what you are implicitly using with the "()" ) does not work in all situations whereas "&" does.
>
> For example if you want to copy an array from one object to another you have to use:
>
*** This is the array
> ACOPY( toParams.&lcVarName, toSource.&lcVarName )
> If you try to use EVAL() here you get only the first element!
>
> Regards
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
>
Tightline Computers Inc, Akron Ohio, USAOf course, I agree, there are certain situations where macro is The Solution, and your example is one of them. Basically, macro is for cases where one needs to use a name (field, alias, another memvar) stored in a memvar, or build a command operating with unknown values. For everything else - "there's the MasterCard" :-) , that is EVAL().
Regards,
Ilya