TTTTT <erlichk...@gmail.com> wrote: > The problem I`m dealing here is that i cant insert other datas into > the table i`ve created except NULL, because i get following error > message: > > Error in select statement : INSERT INTO a (a,b,c,d) VALUES (NULL, > NULL, something_else, NULL) [no such column: something_else].
Your statement should read INSERT INTO a (a,b,c,d) VALUES (NULL, NULL, 'something_else', NULL) Note single quotes around 'something_else'. Without quotes, something_else is an identifier which is supposed to name a column - hence the error. With quotes, it's a string literal. Better still, use a parameterized statement - see http://sqlite.org/c3ref/bind_blob.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
