>>The &lcSqlCmd command below returns a 'Command contains unrecognized phrase/keyword' when executing in a VFP 7 runtime exe.
>>However, there is no error any other time
>>The line break between lines 2 & 3 were inserted when I pasted the code into this message.
>>
>>All assistance is appreciated.
>>TIA.
>>
>>
>>
>>lcSqlCmd = 'Select * from CsmOrdrH into table ' + gcDirTemp + 'ORDRH' + ;
>>' where exists(Select * from CurTemp where CsmOrdrh.IOrdrHid = CurTemp.IOrdrHid)'
>>&lcSqlCmd
>
>Hi Allan,
>
>Can you post content of lcSqlCmd at the time when &lcSqlCmd fails.
>
>Thanks,
>Aleksey.

Aleksey,
Just figured out what the problem is:
On the computer where I was testing the .exe the variable containing the directory name (gcDirTemp) contains a space ('program files...').
On my development system, the directory name is not the same and does not contain a space.