On 3 Jan 2013, at 6:11pm, Simon Slavin <[email protected]> wrote:
> On 3 Jan 2013, at 5:29pm, Quanren Xiong <[email protected]> wrote: > >> Just curious. Do you know how the Visual Studio Designer works? >> In designer, the Null value is converted to 0. > > In SQL null is not 0. 'null' means 'value missing' or 'value unknown'. It > is closer to NaN = NotANumber. It occurs to me that the reason you want NULL to be equal to 0 is that you are adding up some numbers and making a total. In that case compare the definitions of sum() and total() on this page: <http://www.sqlite.org/lang_aggfunc.html> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
