>Hi Guys,
>
>I have a VFP6 App which needs to use macro substitution to update fields in a table. The app works great running from the command line (i.e. running a PRG that runs a form). However, when I create and run an EXE, VFP just skips right over the REPLACE statement! Even stranger, I use a similar technique in another part of the same app with no problems. The code is like:
>
>TVar="T" + ALLTRIM(STR(kSet))
>REPLACE &TVar WITH "AO" + cOrder + cLine
>
>in this case, I have verified that kSet='S51' which is the name of the field I want to update. I have verified that the statements are executing, but NOTHING shows up in the file. I have tried this on several machines with the same result.
>
>Any ideas?
>
>Desperately,
>
>-Arne

Arne,

If S51 is the field name, adding a T to it makes it TS51 which is not the field name.

If T is the table alias, then the syntax would be

TVar = "T." + ALLTRIM(STR(kSet))

And for the second line,

REPLACE (TVar) WITH "AO" + cOrder + cLine

would execute a little faster.

Regards,
Jim