On 12/22/10 10:52 AM, "Simon Slavin" <slav...@bigfraud.org> wrote:
>> There is no way to get a Tcl function to return NULL, since TCL has no >> concept of NULL. So, no, sadly, you cannot get an SQLite function >> implemented in Tcl to return NULL. > > ... but you might find reading this useful: > > <http://wiki.tcl.tk/17441> > Thanks for the pointer. I'm familiar with that page, actually. :-) In my usage, the empty string makes a fine substitute for NULL in my tcl code. The problem is not inserting "" into tables when I really want NULL. Historically, I'd pretty much abandoned the use of NULL; every column had to have an explicit value, and I'd use markers like "" and "NONE" to indicate empty values. But now I'm starting to make use of foreign key constraints, and that solution will no longer fly. Time to learn to do it right. :-) Will -- Will Duquette -- william.h.duque...@jpl.nasa.gov Athena Development Lead -- Jet Propulsion Laboratory "It's amazing what you can do with the right tools." _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
