Did you try using INSERT OR REPLACE? Hugo Ferreira wrote: > Hmmm... Would it be possible to make a trigger on a table such that if any > update fails, it does an insert? > If so, then one would only need to issue updates. > > On Dec 26, 2007 11:35 AM, Kees Nuyt <[EMAIL PROTECTED]> wrote: > >> On Wed, 26 Dec 2007 10:17:43 +0200, Ion Silvestru >> <[EMAIL PROTECTED]> wrote: >> >>>>> QUESTION: is there a better way to make this important decision? using >>>>> Sqlite >>>> INSERT OR REPLACE may work for you. >>> There is a problem with "INSERT OR REPLACE" in that "REPLACE" is not >>> truly <replace>, but is <delete + insert> (existing row is deleted and >>> new row is added), or I am wrong? >> It is a full replacement of the row, just as the word REPLACE >> (Take the place or moveinto the position of) suggests. Perhaps >> you are confused with UPDATE. >> REPLACE has been introduced to increase compatibility with other >> database engines, they all follow the same strategy. >> >>> If I am correct, then a question to developers of SQLite: >>> >>> Is it difficult to change the behaviour of the "REPLACE" part of "INSERT >> OR REPLACE" >>> to be the correct behaviour, row content is updated, and not deleted then >> inserted? >> >> What would be the difference? >> I guess your new row doesn't provide some of the column values >> of the existing row, and you want to keep some of those. In that >> case, SELECT / UPDATE is the only option. >> >> To change the behaviour of REPLACE into selective updating of >> columns SQLite would have to know which columns it would have to >> update and which not. It simply can't. >> >> A nice solution is found in >> Date: Tue, 24 Apr 2007 14:36:48 -0400 >> Subject: [sqlite] Re: INSERT OR REPLACE without new rowid , >> Message-ID: <[EMAIL PROTECTED]> : >> >> IT> You can do >> IT> >> IT> UPDATE ... WHERE keyfield='xxx'; >> IT> >> IT> then use sqlite3_changes to see whether any update >> IT> has in fact taken place, and run INSERT if not. >> IT> >> IT> Igor Tandetnik >> >>> Thanks in advance and happy hollidays! >> HTH >> -- >> ( Kees Nuyt >> ) >> c[_] >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> >> ----------------------------------------------------------------------------- >> >> > >
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
