Over a million developers have joined DZone.

Get LAST_INSERT_ID From Symbian DBMS

·

# table schema
# CREATE TABLE person (id COUNTER, name VARCHAR)

db = e32db.Dbms()
db.begin()  # begin transaction (lock other inserts)
db.execute(u"INSERT INTO person(name) VALUES 'korakot' ") # insert a new row

dbv = e32db.Db_view()
dbv.prepare(db, u"SELECT id FROM person ORDER BY id DESC")
dbv.first_line()
dbv.get_line()
last_id = dbv.col(1)  # get it!

db.commit()  # commit the transaction
Topics:

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}