Thanks for the quick response Michael lots to learn , will get reading now I know what to look for
Laurie Michael Ruck wrote: > I don't know Liberty Basic, but the sqlite3 library allows you to prepare > statements and bind variables to them before executing them. This will solve > your problem. The APIs in question are sqlite3_prepare(_v2), sqlite3_bind_*, > sqlite3_step, sqlite3_reset and sqlite3_finalize. Use these functions (in a > loop) to execute your insert(s) statement(s). The other alternative is to > use sqlite3_mprintf to build a proper sql string. Though I wouldn't > recommend doing it. > > Mike > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von metro > Gesendet: Freitag, 11. April 2008 03:16 > An: sqlite-users@sqlite.org > Betreff: [sqlite] Inserting data containing apostrope > > Hi all > very new to this game, I am creating a reverse search phone book for my POS > program I think the problem has something to do with using an ESCAPE clause > but at this stage it's beyond my comprehension I am using Liberty Basic (new > to that too) + dll how do I insert the following > > INSERT into phone (INITIALS,NAME,PHONE_NO,SUBURB) Values ('AC',' > O'Hara','0413000153','Seafort ') > > thanks in advance > > Laurie > > > > > > _______________________________________________ > 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