Hi Arne,

You don't need macro substituton. The name expression can handle it.

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

Is it possible that table is at EOF() when you're running REPLACE?

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