UPDATE table and quote in a text

Horst baleareninsel at gmx.net
Sun Feb 17 07:24:52 EST 2008

Hi there, 

A  question to all SQL-Masters:
To update a record in a SQL-Table and to store text which includes the "
sign in an SQL-Syntax I learnd, that it is necessary to use

replace quote with "\" & quote in zText
Well, that works fine, but what about The ' sign?

replace "'" with "\'" in zText
seems NOT to work. 

Thanks a lot to all of you and best regards

View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15529083.html
Sent from the Revolution - User mailing list archive at Nabble.com.

More information about the Use-livecode mailing list