Need help on ExecNonQuery2

jinxaw

Member
Licensed User
Longtime User
Hey there,

i'm trying to use ExecNonQuery2 but i get this error:
sqlite bind or column index out of range exception

My code:

B4X:
map1 = json.NextObject
db.BeginTransaction
Dim l1 As List = map1.Get("delete_dealer")
db.ExecNonQuery2("update products set id_portrait = null where id_portrait = ?",l1)
db.ExecNonQuery2("delete from portraits where id = ?", l1)

l1 is filled with the following values at this time [5, 7, 8].
Am i missing something?
 

stevel05

Expert
Licensed User
Longtime User
What is the data type of id_portrait in the database. I don't think you'll be able to save a list directly. You may be able to save it as a Blob, but You may need to convert it to a string.

-------------------
Sent via Tapatalk
 
Last edited:
Upvote 0
Top