The test this time was:
sqlite> create table t1 (Col1,Col2);
sqlite> insert into t1 (Col1) values ('xxx');
sqlite> select * from t1;
xxx|sqlite> create table t2 (Col1, col2 not null default 'abc'); sqlite> insert into t2 SELECT * from t1; SQL error: t2.col2 may not be NULL -- Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
