>>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? 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? Thanks in advance and happy hollidays! ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
