On 5 Jan 2011, at 5:27pm, tinauser wrote: > I create a table with a field NOT NULL > However i succesfully insert a record with the NOT NULL field empty.
Please excuse the very simple questions. I'm not saying you've done anything wrong, it's just difficult to figure out what's happening without this background information. What makes you think that the field is empty ? Are you sure that the field evaluates to NULL, or is it perhaps a blank string (a zero-length text value) ? Are you doing this with the sqlite3 command-line tool ? Or are you using a 3rd Party GUI application ? Or are you writing your own C code ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
