Taking into consideration a declared close relativity between SQLite and
TCL, I would to suggest an improvement in boolean-type fields treatment.
In my opinion, field of that type should be treated equally, when it does
contain a values: "f", "false", 0, "no" - and, respectively: "t", "true",
1, "yes".
You know, what I mean: if "checkIt" field contains value, which can be
described as FALSE, a clause: "... WHERE checkIt='0'" should return "true"
independent of the fact, which one of the four strings it does contain ("f",
"false", 0, "no"). Of course, only in the case, when "checkIt" has been
declared as "BOOLEAN", and not as "TEXT" for example.
What do you think?
--
pozdrawiam / regards
Zbigniew Baniewski
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
