John wrote: > > You might also want to look at using triggers to auto insert the > datetimestamp as your entries are inserted/updated. >
For completeness, you may also want to look at the DEFAULT time and date codes; CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP at http://www.sqlite.org/lang_createtable.html. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users