We can't do much without actually having a look at your schema. Please give us the output of .schema <table>
Also try "pragma table_info(table);" It will say you whether that column can be null or not. create table xxx ( a integer not null); pragma table_info(xxx); it should show you something like 0|a|integer|1|0 if the field after integer is 1 then the column is not null, else it can null :) hope it helps for you to debug Venkat Bug the bugs On Thu, Jan 6, 2011 at 6:34 PM, Black, Michael (IS) <michael.bla...@ngc.com>wrote: > Care to show us your SQL? You likely missed something... > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Northrop Grumman Information Systems > > > ________________________________ > > From: sqlite-users-boun...@sqlite.org on behalf of tinauser > Sent: Wed 1/5/2011 11:27 AM > To: sqlite-users@sqlite.org > Subject: EXTERNAL:[sqlite] NOT NULL > > > > Hi there, > I'm an inexpert user of SQLite. > I create a table with a field NOT NULL > However i succesfully insert a record with the NOT NULL field empty. > Shouldn't this be "forbidden"? > Thanks > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
