Is there a primary key on the table? Is it possible to use insert or replace instead of update, and then not reference the column you want to set as a default?
On Thu, May 6, 2010 at 10:41 AM, Andy Gibbs <andyg1...@hotmail.co.uk> wrote: > > You could write a trigger that sets default value if NULL is inserted > > or set via UPDATE. > > That's a great idea - thanks! It won't work in all the places since in > some > places 'NULL' is a valid value, but I'm sure I can think of a work-around. > > Thank you!! > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
