On Mon, Mar 12, 2012 at 9:02 AM, Christian Smith <csm...@thewrongchristian.org.uk> wrote: > On Fri, Mar 09, 2012 at 09:49:22AM +1100, BareFeetWare wrote: >> I suggest only using "insert or replace" if you genuinely want to delete and >> replace with a new row. This is generally not hat you want if there are any >> foreign keys. >> >> Only use "insert or ignore" if you are inserting exactly the same row as >> what might already be there. >> >> Otherwise use a combination of insert and update. >> >> So, for example, if you are wanting to add a person that may not already be >> in your table: >> >> insert or ignore into "Person" ("First Name", "Last Name", "Company", >> "Email") >> select 'Tom', 'Brodhurst-Hill', 'BareFeetWare', 'develo...@barefeetware.com') >> ; >> update "Person" >> set "Email" = 'develo...@barefeetware.com' >> where "First Name" = 'Tom' and "Last Name" = 'Brodhurst-Hill' >> ; > > I've had a similar problem in the past, and solved it by using a pre-insert > trigger to do the desired update.
Ah, yes, thanks! Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users