On 28 May 2009, at 9:00am, Damien Elmes wrote: > alter table cardModels add column allowEmptyAnswer boolean not null > default 1
> sqlite> update cardModels set allowEmptyAnswer = 0; You're obviously used to other implementations of SQL. 'boolean' isn't a legit type name: http://www.sqlite.org/datatype3.html This may or may not be the cause of the problem you report, but fix it first. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users