Android Question How do I get value of an auto increment field, after insert

[davepamn]

I want to get the id value of the an auto increment field in sqlite . What cursor method will return the id value

 

[EnriqueGonzalez]

why dont you use a Max function for the ID, it will always return the last entered.

 

[davepamn]

I was hoping for a scalar value that I could reference in the cursor

 

[Jeffrey Cameron]

See this post: https://www.b4x.com/android/forum/t...ate-an-integer-primary-key.12679/#post-103239

 

[davepamn]

I use auto increment and am looking for a way to get the scalar value without out running a max id or desc id sort. if this is not possible I will run a query to get the id.

 

[Jeffrey Cameron]

Did you not read the post in the link I provided?

The important bit in the link was the

RowID = SQL1.ExecQuerySingleResult("SELECT last_insert_rowid() FROM table1")

This will provide you with your scalar value of the ID that was added. I figured it was better to link the post and provide credit where credit is due rather than rehash it.

 

[davepamn]

thanks

When I first saw that I thought it was return the hash value for the record