On Thu, Jan 08, 2009 at 06:30:38AM -0800, liron.levy10 scratched on the wall: > > i am trying to use the "insert or replace" query command , and "insert" is > the command who executed always even though the query is alredy exist. and > the right command to use is "replace" command > someone know what is the problem?
A conflict only occurs on columns marked UNIQUE. So you must be inserting an explicit value into a UNIQUE column that already has that value. Also, REPLACE is not an UPDATE. If an existing column is found that would have caused a UNIQUE constraint violation, it is DELETEed, and then the new row is then INSERTed. REPLACE does not convert an INSERT into an UPDATE. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
