Problem with SQLite autoincrement field in Listview

S

serdar

New Member
Licensed User
Longtime User
Hello and thanks for great app.

I have a simple SQlite table with one autoincrement and one text fields and I populated Listview with table showing only the text fields.

Then I select a row to get Position value to delete or edit text field. But Position Value does not match with actual autoincrement number.

Is there a way to get selected records autoincrement field value in Listview without listing actual autoincrement value itself ?

Serdar,
 
Sort by date Sort by votes

NJDude

Expert
Licensed User
Longtime User
You could save the records from the database to a List, in this case you will save the autoincrement field, so, when the user click on the list view, you use the index of the list view to grab the autoincrement value and retrieve your record from the DB.
 
Last edited:
Upvote 0

Ricky D

Well-Known Member
Licensed User
Longtime User
That's the easiest way to do it

cheers, Ricky
 
Upvote 0
S

serdar

New Member
Licensed User
Longtime User
Thank you for help it works. But filling Listview and a seperate List takes a long time and memory for long tables with a lot of fields.

I figured that I can extract autointeger KeyValue within Itemclick Sub. Provided that Text value is unique.

Thanks
Serdar,

B4X: 
Sub Listview1_ItemClick (Position As Int, Value As Object)
        Dim KeyValue as Int
   KeyValue=SQL1.ExecQuerySingleResult("SELECT AutoInt FROM MyTable WHERE Text='" & Value & "'")
End Sub
 
Upvote 0
F

flandersdl

Member
Licensed User
Longtime User
Are you using .AddSingleLine2? You could put the auto increment in the ReturnValue and then use it to delete or edit the text.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

M
  • Question
Android Question SQLite ID INTEGER PRIMARY KEY AUTOINCREMENT Insert
Replies
2
Views
4K
Mahares
M
R
  • Question
Android Question SQLite db with Primary key as an autoincrement
Replies
19
Views
4K
Richard S
R
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
143K
Erel
I
  • Question
Android Question Not autoincrement primary key
Replies
6
Views
2K
ivavilagu
I
C
  • Question
Autoincrement Field
Replies
2
Views
2K
cnicolapc
C
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…