Re: [sqlite] problem with inserting non NULL values into sqlite table

hey! Thank you very much.. i wanted to insert string and i have forgotten about a fact i need to use these quotes ' '.. that has solved the problem... Thank you.. Nataraj, i am using sqlite3_exec function to get error... and yes, call back is one of arguments passed to the function.. che

Re: [sqlite] problem with inserting non NULL values into sqlite table

Hi How do I catch a error raised by a trigger from a programming language like C++ or freepascal? Do we have a call back to do the same? regards Nataraj On Thu, Oct 29, 2009 at 8:36 PM, T wrote: > > hello everyone ! > > I`m trying to use sqlite database with c++, but something isnt wo

Re: [sqlite] problem with inserting non NULL values into sqlite table

T 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].

Re: [sqlite] problem with inserting non NULL values into sqlite table

> Error in select statement : INSERT INTO a (a,b,c,d) VALUES (NULL, NULL, > something_else, NULL) [no such column: something_else]. So what are you trying to insert by this statement? What is "something_else"? If you suppose it to be a string then you have to enclose it in single quotes like this:

[sqlite] problem with inserting non NULL values into sqlite table

hello everyone ! I`m trying to use sqlite database with c++, but something isnt working right... 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) VAL