2009/9/20 Guillermo Varona Silupú <gvaro...@hotmail.com>: > Hi > I want to insert this text: > > 1' equivale a 12" > > cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a 12"")
INSERT INTO Tabla1 (Code,Equiv) VALUES (10, '1'' equivale a 12"'); > > TIA > Best Regards > GVS > > P.D.: Sorry for the post past and my bad english > > single quotes to delimit string literals. Double them up to escape them inside a string literal. See http://www.sqlite.org/lang_expr.html#litvalue Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users