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

Reply via email to