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
