I've been talking with Bogdan about a change to SQLite Expert and ran
across something I did NOT expect.

I have this schema:

CREATE TABLE [tApplicationPaths] (
  [AppID] INTEGER PRIMARY KEY,
  [ApplicationName] CHAR,
  [ApplicationMonitorPath] CHAR,
  [SearchSubDirs] BOOL DEFAULT 1,
  [SearchMask] CHAR DEFAULT AppID);

When I insert a new row, I get the literal string "AppID" as a default
value for that new row.  I was expecting a number or null, or something.
Not a string.  Is this intended behavior?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to