Android Question How to use DBUtils.DeleteRecord(Starter.SQL1,"Students", !?)

Theera · Dec 23, 2020

In The first activity,I have success for map data as code belows

Dim ListOfMaps As List
ListOfMaps.Initialize
For i = 1 To 40
Dim m As Map
m.Initialize
m.Put("Id", Id)
m.Put("First Name", "John")
m.Put("Last Name", "Smith" & i)
ListOfMaps.Add(m)
Next
DBUtils.InsertMaps(Starter.SQL1, "Students", ListOfMaps)

and another activity,I use webview to show database

WebView1.LoadHtml(DBUtils.ExecuteHtml(Starter.SQL1,"SELECT [Id],[First Name] || ' ' || [Last Name] As Name From "Students",Null,0,True))

Now,I need to delete the record from WebView1 after I click and get the row ,I can't set the map in the command and update webview

DBUtils.DeleteRecord(Starter.SQL1,"Students", !?)

I'm sorry my English.

LucaMs · Dec 23, 2020

It should be:

B4X:

DBUtils.DeleteRecord(Starter.SQL1, "Students", CreateMap("Id":HereTheIdYouSeleted))

Theera · Dec 26, 2020

LucaMs said:
It should be:

B4X:

DBUtils.DeleteRecord(Starter.SQL1, "Students", CreateMap("Id":HereTheIdYouSeleted))

It 's correct only the first time's deletion ,and then I need to delete the record again ,the row is not equal to ID. How do I get ID from the row which is selected?

Theera · Dec 27, 2020

Ok My problrem is solved myself. Thank you for kind of you,LucaMs

row= values(1)
'Delete Record which is selected
ToastMessageShow(row,False)
Dim Csr As Cursor
Csr = SQL1.ExecQuery("SELECT ID FROM Students")
Csr.Position = row
ToastMessageShow("Cursor=" &Csr.GetInt("ID") ,False)
DBUtils.DeleteRecord(SQL1,"Students", CreateMap("ID":Csr.GetInt("ID") ))

Android Question How to use DBUtils.DeleteRecord(Starter.SQL1,"Students", !?)

Theera

Expert

LucaMs

Expert

Theera

Expert

Theera

Expert

Similar Threads

Android Question How to use DBUtils.DeleteRecord(Starter.SQL1,"Students", !?)

Theera

Expert

LucaMs

Expert

Theera

Expert

Theera

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency