Hi,
In the table created below: CREATE TABLE
AA (column1 INTEGER,
column2 INTEGER NOT NULL,
column3 REAL NOT
NULL,
column4
INTEGER NOT NULL DEFAULT -1000,
PRIMARY
KEY(column1)) I tried adding rows manually using sqlite3 command shell. It
does not take a row without inputing column4. It seems default value (-1000)
does not take effect. When forced to input a row without column 4 (by using
.import <file> <table> in sqlite3 shell), the value for column4 got back from
the db is always 0. Am I missing anything? It seems that I am not able to make
the default value work for a "NOT NULL" table field. Thanks a lot,pam
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
