Holá Mark, The main question seems to be: How to "include" a textfile for example: .. put "1234'5'6öä'ioup"#" into mytext ## I know, this text is senseless, but never mind, it should be able to be saved replace quote with "\" & quote in mytext ## and then, how to replave the ' ??? put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage revexecutesql (my_ID), sql_message put the result ## shows an SQL-Error message and mytext will not be saved ..
best regards and, as usual, a big thank You for answering Horst Mark Schonewille-3 wrote: > > 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 > > -- View this message in context: http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15530593.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
