SQLite Query!!!!

[shekhar_dawer]

Hi all,
Can anybody help me to create query , to find out the key_id(primary key)
for the last saved record.
Key_id is not sequential it can be any random no.

Any help will be appreciated.

Thanx

[Andy Tacker]

well if you will search MSDN or even MS SQL Book, you will find the way to create a stored procedure which will return the ID after insertion.

be a little lazy to do a search. ;)

Andy

[hspc]

use : sqlite_last_insert_rowid()
http://www.sqlite.org/faq.html#q1 (http://www.sqlite.org/faq.html#q1)