On Oct 8, 2014, at 8:51 PM, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> If the field def'n were to be changed to [ col2 NUMBER DEFAULT ON NULL 0 ] > and then when I insert/update something that becomes NULL and the result > becomes 0 for that field, then yeah, bingo. Yep, that’s exactly what it says on the tin. But back to SQLite... your best bet is to implement such behavior with triggers. Same difference really. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users