Alejandro Ruiz-Oriol wrote: > Use old.TypeID==1 if you want the trigger to be fired when TypeID WAS 1 > before the update, or new.TypeID==1 if you want the trigger to be fired when > TypeID is updated to 1. > > Hope this help... >
Thank you for the reply - my original problem wasn't exactly that, but appreciate your help in any case! Dennis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users