> > 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. >
Hi Simon, Yes correct because if you alter a table with a new BOOLEAN column with a default value, all existing row still have NULL as value. I think in a correct way the ado provider has to return the default (in my case 0 = false) value if field is NULL and not throw these error. I think this is a bug. Do you with me? Regards Steffen
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
