Android Question Getting Blob from a Database

Jinora29

Member
I read the tutorial for getting a blob and an image from a database, but I couldn't understand it properly and when I write the code that is in that tutorial, the program doesn't work.
Can someone tell me what the appropriate code is?
This is my code for getting text...
B4X:
Dim rs As ResultSet
    rs = Starter.sqll.ExecQuery2("SELECT Text from Datable WHERE Date=?" , Array As String(total))
    If rs.NextRow Then
    Label1.Text = rs.GetString("Text") 
    End If
    rs.Close

Sorry if I'm asking too many questions today 😅
 

klaus

Expert
Licensed User
Upvote 0

Mahares

Expert
Licensed User
I used the codes written in this
What is 'this'. You do not mention what 'this' is. I think you are making it a little harder for anyone to help here. You really need to show what code you used to extract the blob, then it would be easier to help
 
Upvote 0

klaus

Expert
Licensed User
The code you show in post #1 is not for an image!

You need to check the SQL library in the Libraries Manger.

It seems that in another thread you have already a working project with a SQLite database so it should work.
 
Upvote 0
Top