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