sqlite: Sqlite Parameterized insert query (escape)

mercredi 8 avril 2015

Hi I try to use SQLite Parameterized query but in the column name is a DOT (.)


INSERT INTO Data (test.1, test.2, Test.3) VALUES (@test.1, @test.3,@test.3)

Returns

"SQL logic error or missing database near ".": syntax error"


INSERT INTO Data (test.1, test.2, Test.3) VALUES ([@test.1], [@test.3],[@test.3])

Returns

"SQL logic error or missing database no such column: @test.1"

how can i escape the dot and still use the names as parameters!?

sqlite