Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1493 passing long SQL Statement
Message
From
13/11/2020 02:25:33
 
 
To
13/11/2020 02:18:42
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01676940
Message ID:
01677125
Views:
49
>>>That is usually happened to me when I copy the query from SSMS (MS SQL Server) and pasted it in VFP. Then all Unicode chars than is not English ones become question marks :-)
>>
>>I use the ?pcParameter for the parameters, and checked all just in case, so they are all correct.
>
>Checked all parameters or all question marks? A question mark in the comments was the cause when it happened to me. Parser doesn't disregard the SQL comments, it just parses the whole command.

Yes indeed, in my case it was also a questionmark in a comment. Good to know that this causes an error which is difficult to understand at first.
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform