Android Question Blob PDF

[makis_best]

Hi.

I have some pdf files inside my sqlite database in blob format.
How I can open them so I can read them inside my application?
I need to use any specific library?

Thank you.

 

[amykonio]

Hi.
You can read blobs using the result from an execquery or execquery2 command. That will return a cursor.
From that cursor you can access your blob using one of the following methods:

Dim Buffer() As Byte
Buffer = Cursor.GetBlob("col1")

or

Dim Buffer() As Byte
Buffer = Cursor.GetBlob2(0)

It can be achieved using sql library.
You can save the contents of the buffer to a file... And use it later as you want.

Andreas.

 

[makis_best]

Thank you @amykonio I get it.
But what view should I use to open and read pdf?

 

[amykonio]

I'm not sure if you want to open and read its content to use them inside your application (some kind of data extraction) or if you simply want to show the pdf to the corresponding application.

 

[makis_best]

Why not to open it inside my application?