"Roger Binns" <rog...@rogerbinns.com> wrote in message news:4a1127e1.1040...@rogerbinns.com > If you also ask for the ROWID you will see that what is happening is a > new rowid is generated for the replaced row so that if you are > iterating over the table while modifying it then you effectively have > an infinite length table.
Note further that, since there are no UNIQUE or PRIMARY KEY constraints on any columns, REPLACE INTO is equivalent to INSERT INTO. In other words, no rows are being deleted, just new ones added. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users