On 18 Apr 2012, at 1:44pm, Steffen Mangold <steffen.mang...@balticsd.de> wrote:
> I have an existing table filled with data and want to add a new column like > "IsReplaced BOOLEAN NOT NULL DEFAULT 0" > All worked fine but if I now try to read a data row I gat an exception from > the sqlite ado provider that he can not map NULL to Boolean. > Why is the default value is not working correct with Boolean column? (and yes > I know that BOOLEAN in Sqlite is saved as integer, for that I use "DEFAUL 0") I think your problem is with the ado provider. Perhaps it makes the assumption that every value in a BOOLEAN column must be a BOOLEAN. This is not true under SQLite: you can have any value in a BOOLEAN column, even TEXT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
