Did you try doubling the apostrophes? *Goin'' Down the Road Feelin'' Bad*
On 4/17/2011 6:16 PM, Simon Slavin wrote: > On 17 Apr 2011, at 11:54pm, Alan Holbrook wrote: > >> I'm using SQLite with VBE2008. I've defined a table with a number of text >> fields in it. If the information I want to write to the database contains >> an embedded apostrophe, the program throws an error. That is, if I set >> textfield1 to *Going Down the Road Feeling Bad*, the data gets written >> correctly and the program continues. But if I set textfield1 to *Goin' Down >> the Road Feelin' Bad*, I get an error. >> >> Is there a way I can use an apostrophe in the data to be written? > Your library might do it for you. If you're writing directly to the SQLite > library then I believe you can double the apostrophe: > > Goin'' Down the Road Feelin'' Bad > > so it might be worth trying that. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
