Thanks for the help! It turned out that the trigger was correct (and I also was using a default value). I am using SQLITE3 Managment Studio v3.7.9 and the default value was not being picked up during a insert using the IDE. For unknown reasons the trigger solves the problem.
Thanks again for all the help. Jan Zumwalt -- View this message in context: http://old.nabble.com/Need-trigger-tp32966496p32969834.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

