On 12/22/10 10:35 AM, "Richard Hipp" <[email protected]> wrote:
On Wed, Dec 22, 2010 at 1:16 PM, Duquette, William H (318K) < [email protected]> wrote: > If I define a custom SQL function in Tcl using the SQLite "$db function" > command, is there any way to make the function return NULL? I'm guessing > not. > 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. I imagine one could write an SQL function in C that returns NULL, though, right? What if the API included a function null(x) that returns NULL if x is the "nullvalue" string specified with [$db nullvalue], and x otherwise? -- Will Duquette -- [email protected] Athena Development Lead -- Jet Propulsion Laboratory "It's amazing what you can do with the right tools." _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
