[sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

2008-10-21 Thread Kenneth McDonald
Basically, my database INSERT commands seem to still expect a value for this, even though my expectation is that it will be computed automatically, starting with (I assume) a default of 0 or 1. But I'm getting errors of the sort "table images has 12 columns but 11 values were supplied." Is

[sqlite] Any way of using an implicit BTree ordering in SQLite?

2004-12-14 Thread Kenneth McDonald
Normally (to my understanding), a BTree of some sort is declared on a set of columns of a table when an index (or something which requires an index) is declared on that set of columns. However, I'd like to use a table as a "pure" BTree, i.e. one in which the order is not dependent on values in