Hi All,

I'm having an uphill battle with a command that is macro substituted.

It's an UPDATE table SET var=1 command. I'm doing something like

lcWholeCommand = "UPDATE table SET var=1"
&lcWholeCommand

Now, the command is quite large and certainly exceeds 1000 characters. According to the help files this isn't a problem as VFP and handle commands that are 8192 characters long.

However, the macro substitution fails with a "commnad contains unrecognised phrase or keyword"

If, when my program has crashed I copy the lcWholeCommand to _CLIPTEXT and paste it into the command window, I get something really odd, Fox splits the command across two lines. If I execute the command with a semi colon between the two lines everything's ok.

BTW some of the var= parts of the command include memo fields which is why the command is so long.

Hope this makes sense.

Best wishes

Paul Robinshaw