While Keith is closer to the right explanation than I was, there are a
couple of points:
default does not need a constant: a function call is valid as well,
e.g. date()
The syntax:
CREATE TABLE tApplicationPaths (
AppID INTEGER PRIMARY KEY,
ApplicationName CHAR,
ApplicationMonitorPath CHAR,
SearchSubDirs BOOL DEFAULT 1,
SearchMask CHAR DEFAULT [AppID]);
doesn't deliver the expected default value to SearchMask (for reason
Keith exposed), but it doesn't bark either and simply insert 0 as
default value AFAICT.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users