Hello,
I was thinking on a new option that could be useful for sqlite. A new conflict clause called "update" so that the following SQL command: insert or update into table1 (a,b) values (1,2) was equivalent to update table1 set a=1,b=2 where ?unique-key-constraint? when a unique key contraint is hit. I think that it could have advantages over the "replace" conflict clause for the very usual case that a new record must be updated or inserted if it does not exist. What is your opinion on this? -- Compass Ing. y Sistemas Dr. Ramon Ribo http://www.compassis.com [EMAIL PROTECTED] c/ Tuset, 8 7-2 tel. +34 93 218 19 89 08006 Barcelona, Spain fax. +34 93 396 97 46 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
