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