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:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}