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

Reply via email to