I'm a great believer in using CHECK constraints to do as much validation as possible within the database rather than code it in my application.
However, I think I'm right in saying that as soon as a CHECK constraint fails, an error is returned to my application so no other CHECK constraints are executed In a data entry type of application, this isn't ideal as users would prefer to see all the errors they need to correct in one message. I can't think of a way round this but wondering if anyone has found a technique to return all CHECK constraint errors at once. Pete lcSQL Software <http://www.lcsql.com> Home of SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users