Dear all,
I have been gazing my code for amount 20 minutes now and I really need your
help with this silly yet simple code.
CREATE TABLE testing(
id integer primary key,
name text not null default 'hello');
* If I insert an empty row with null values, it does not work.
* If I insert an N value to id, name adds default string as its value.
* If I insert any character in name, id automatically adds a value.
* If I run this line "insert into testing default values;" it works
just fine.
Can you clarify this just a bit please about the first line with null values?
I know that sounds silly since I have declared my name as not null, but should
not the shell caught this and check for its default alternative if any?
Regards,
Stefanos
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
