On 13/01/12 00:17, Tony Caras wrote:
UPSERT (really means update the record if it exists otherwise insert the record)
AFTER INSERT (I meant a trigger after an insert. In this case I have access
to the new value but not the "old" values in the record.)
If UPDATE would insert the record if it didn't exist then I could use the
trigger you have suggested.
two triggers? one AFTER INSERT, one AFTER UPDATE.
jr.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users