I tend to use an UPDATE ... WHERE EXISTS ...; followed by an INSERT ... WHERE NOT EXISTS ...;, which gives me insert or update semantics.
Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users