UPDATE table and quote in a text
m.schonewille at economy-x-talk.com
Sun Feb 17 06:45:28 CST 2008
Single quotes should be escaped the way you do and this should work
fine. I have seen reports of commands starting with revdb being
unable to escape single quotes, but this can be solved by using
revExecuteSQL -- I don't know whether there really is a bug with
escaping characters, I didn't encounter this problem myself. Make
sure that you only replace single quotes that are part of the data
and not the two single quotes that surround the string.
Economy-x-Talk Consulting and Software Engineering
Convert colours between different colour spaces with Color Converter.
Download at http://economy-x-talk.com/cc.html
Op 17-feb-2008, om 13:24 heeft Horst het volgende geschreven:
> 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-
> Sent from the Revolution - User mailing list archive at Nabble.com.
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode