Thanks so much for everyones help for all the db questions I recently had as well for all the help over the years!
We just blogged about our new template for created web apps for small businesses using Xojo along with the code we used to auto generate SQLite triggers for an AuditLog.
http://campsoftware.com/blog/xojo-xanadu-sqlite-audit-log-using-triggers