I'm using SQLite in a performance-intensive data conversion process and it's come about that it would be very useful to get the insert_rowid of the last record inserted while I'm still in the middle of a transaction of servert hundred inserts(the primary key will become a foreign key to a child table).
Can I get a reliable rowid from this call while I'm in the middle of a transaction, without interrupting the transaction? The large transactions are too important to sacrifice just to get this information, but it would make the programming a lot easier to have this data. Clay -- Simple Content Management http://www.ceamus.com