> > 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") >
Sorry mail was not finished. I forgot: Thanks for your help. Regards Steffen :)
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
