Hi guys,

i have a little problem with BOOLEAN data column.

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")

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to