Guillermo Varona SilupĂș wrote: > I want to insert this text: > > 1' equivale a 12" > > cQry := "INSERT INTO Tabla1 (Code,Equiv) VALUES (10, "1' equivale a > 12"")
What language is that? ':=' suggests Pascal, but string literals in Pascal use single quotes. In SQL, string literals are surrounded by single quotes: if you need a single quote as part of the string, you enter two of them in a row. Double quotes don't require any special handling inside a string literal. INSERT INTO Tabla1 (Code,Equiv) VALUES (10, '1'' equivale a 12"') Now that you have a valid SQL statement, figure out how to represent it as a string literal in whatever host language you are using. Igor Tandetnik
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users