Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace chr(13) + chr(10)
Message
From
30/03/2019 13:45:37
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667754
Message ID:
01667761
Views:
60
>When inserting a string into a VFP table (using INSERT INTO command) and a string contains characters chr(13) and chr(10), I get error: "Command contains unrecognized phrase/keyword." The SQL Server DB has no such a problem.

Your carriage return is being interpreted in cSqlCommand. Thus, this results in this.

You might want to try to parameterize your values. So, they won't affect cSqlCommand.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform