Hi All, Following this thread, I was experimenting with last_insert_rowid(), and found the following, which does not look right:
SQLite version 3.4.2 Enter ".help" for instructions sqlite> sqlite> create table tmp( a integer, b integer ); sqlite> create unique index tmpIndex on tmp( a, b ); sqlite> insert into tmp values( 1, 1 ); sqlite> insert into tmp values( 2, 2 ); sqlite> select last_insert_rowid(); 2 sqlite> sqlite> insert or replace into tmp values( 1, 1 ); sqlite> select last_insert_rowid(); 3 <------ !!!???!!! sqlite> select * from tmp; 2|2 1|1 sqlite> Rgds, Simon ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
