Re: [sqlite] Getting the rowid after an insert

2009-11-25 Thread Simon Slavin
On 26 Nov 2009, at 5:54am, Edward Diener wrote: > I have a table with an integer primary key as the first type. My > understanding is that this is an alias for the rowid. When I insert a > row in this table using _sqlite3_prepare and then sqlite3_step I need to > retrieve the rowid for the

[sqlite] Getting the rowid after an insert

2009-11-25 Thread Edward Diener
I have a table with an integer primary key as the first type. My understanding is that this is an alias for the rowid. When I insert a row in this table using _sqlite3_prepare and then sqlite3_step I need to retrieve the rowid for the row I have just inserted. Is there an SQL statement I can