> 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() It can be a "constant expression" if surrounded by brackets. This does not mean that the value of the expression is a constant, rather that the expression is constant. Create table a (id integer primary key, date text default (date())); There is, however, no way to refer to a column by name or embed a correlated subquery as a default ... > 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. For me this inserts the text 'AppID' ... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
