Thanks to all for all the suggestions. Doubling up the apostrophe worked. On Mon, Apr 18, 2011 at 10:55 AM, Jim Morris <jmor...@bearriver.com> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
