[sqlite] Using last_row_insert() with sqlite3_prepare() and friends.

[g...@novadsp.com]

Using SQLite version 3.7.7.1 (Windows/VS2008).

A table has an integer autoincrement primary key, the value of which is 
being used to feed an R*Tree index. I am attempting to insert data and 
retrieve the latest row_id() in a compound statement like this using the 
SQLite C API:

"INSERT INTO table (columns) VALUES(?,?,?,?); SELECT last_insert_rowid() 
FROM table;"

which works in the Sqlite3 console. However when I run this 
sqlite3_step() returns SQLITE_DONE.

sqlite3_prepare();
sqlite3_bind_xxx();
sqlite3_step();

Can anyone point out what I am missing?

Thx++.




_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users