Ok Thank you
2011/2/23 Kostya Vasilyev <[email protected]>
> If the insert() was called from your own code, you could save the return
> value.
>
> Otherwise, use db.rawQuery("SELECT last_insert_rowid()", null), and get the
> value from the cursor.
>
> -- Kostya
>
> 23.02.2011 21:29, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ пишет:
>
> Yes but, if i understood well that i read, this procedure is used to insert
> an new row in the table. I don't have problem with this. i want to use the "
> SELECT last_insert_rowid()" string to get the last row id inserted in any
> table in database.
>
> 2011/2/23 Kostya Vasilyev <[email protected]>
>
>> See this:
>>
>>
>> http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insert(java.lang.String,
>> java.lang.String, android.content.ContentValues)
>>
>> Returns
>> the row ID of the newly inserted row, or -1 if an error occurred
>>
>>
>> Same with ContentProvider, except you get back a Uri for the new item.
>>
>> -- Kostya
>>
>> 23.02.2011 21:16, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ пишет:
>>
>> How to use "SELECT last_insert_rowid()" in
>> android environment?
>> Thanks in advance
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Android Developers" group.
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]
>> For more options, visit this group at
>> http://groups.google.com/group/android-developers?hl=en
>>
>>
>>
>> --
>> Kostya Vasilyev -- http://kmansoft.wordpress.com
>>
>> --
>> You received this message because you are subscribed to the Google
>> Groups "Android Developers" group.
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]
>> For more options, visit this group at
>> http://groups.google.com/group/android-developers?hl=en
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>
>
>
> --
> Kostya Vasilyev -- http://kmansoft.wordpress.com
>
> --
> You received this message because you are subscribed to the Google
> Groups "Android Developers" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/android-developers?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
