Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem to use apostrophe in a text string when using UP
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00654499
Message ID:
00655479
Views:
33
Sergey,

You are right. It works like this:
cUpdateString = [UPDATE BEST SET ] + lprFieldName + [ = '] + lprFieldValue + ['] + ;
[ WHERE BESTNR=] + Transform(nBestnr)
but it does not work like this:
lcUpdateString = [UPDATE BEST SET ] + lprFieldName + [ = '] + [lprFieldValue] + ['] + ;
[ WHERE BESTNR=] + Transform(nBestnr)
as was proposed to overcome the problem with doubble quotes. However, when the command is written like the first one above I find now no problem to transfer doubble quotes to the SQL-table.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform