On Apr 17, 2011, at 5:54 PM, Alan Holbrook <isaac.laqu...@gmail.com> 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?
Escape the apostrophe using the conventions of your VBE2008, or better yet, use
bind values.
> _______________________________________________
> 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