sqlite> create table x (key integer primary key, value text); sqlite> insert into x values (null, 'test'); sqlite> update x set key=10000 where value='test'; sqlite> select * from x; 10000|test sqlite> delete from x; sqlite> insert into x values (null, 'again'); sqlite> select * from x; 1|again sqlite> drop table x; sqlite> create table x (key integer primary key autoincrement, value text); sqlite> insert into x values (null, 'test'); sqlite> update x set key=10000 where value='test'; sqlite> select * from x; 10000|test sqlite> delete from x; sqlite> insert into x values (null, 'again'); sqlite> select * from x; 2|again sqlite> drop table x; sqlite> create table x (key integer primary key autoincrement, value text); sqlite> insert into x values (null, 'test'); sqlite> update x set key=10000 where value='test'; sqlite> select * from x; 10000|test sqlite> insert into x values (null, 'again'); sqlite> select * from x; 10000|test 10001|again sqlite>
Question is: when the rowid alias is declared autoincrement, Should the "update" update the hi-level mark for the key field? --- Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!" -- Hunter S. Thompson _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users