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:
00655506
Views:
40
>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.

Sorry, it was typo. There shouldn't be brackets around lprFieldValue.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform