Dear Horst,
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.
Best regards,
Mark Schonewille
--
Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
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
Horst
--
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.
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
