Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error in SQL Command when running .exe
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00811923
Message ID:
00811924
Views:
11
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform