SQLite Auto Increment

[pa3ck]

Hey.

I used to use MySQL instead of SQLite but I gotta use SQLite this time. I'd like to know how to get the last auto_increment value? I know I can count up the data and get the value but I'm sure there's an easier way. In MySQL it's:

local query = dbQuery ( connection, "SHOW TABLE STATUS LIKE 'theTable'" ) 

[Addlibs]

You could select all rows, check the values of the last one and add 1. This should work - not fully tested under all circumstances but it does the job.

[DiSaMe]

SELECT LAST_INSERT_ID()