Android Question ERROR READING BLOB IMAGE DATABASE SQLITE !!

LucaMs

Expert

Licensed User

Longtime User

• Jan 22, 2016

• #2

MarcioCC said:

no such column: name

Click to expand...

TBFILMES has not a column named "name"

(in your post a comma misses before Array As String)

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 22, 2016

• #3

hit the column more now ta giving this error: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 22, 2016

• #4

the mistake is giving this line: Buffer = Cursor1.GetBlob("FOTO")

 

Upvote 0

LucaMs

Expert

Licensed User

Longtime User

• Jan 22, 2016

• #5

Check Cursor1.RowCount and set cursor position

 

Upvote 0

LucaMs

Expert

Licensed User

Longtime User

• Jan 22, 2016

• #6

("FOTO" or "PHOTO"?)

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 22, 2016

• #7

FOTO

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Jan 23, 2016

• #8

The error is giving this line: Cursor1 = s.ExecQuery2 ("SELECT PHOTO FROM TBFILMES WHERE name =?" Array As String (""))

Click to expand...

B4X:

Cursor1 = SQL1.ExecQuery2("SELECT FOTO FROM TBFILMES WHERE name = ?", Array As String("TheImageNameYouWantToGet"))

as @LucaMs suggested .. after your query check cursor rowcount ..

B4X:

Log(Cursor1.RowCount)

Cursor1.Position = 0
Dim Buffer() As Byte 'declare an empty byte array
Buffer = Cursor1.GetBlob("FOTO")

It might be better if you post the full sub for a clearer look at your code ..

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 23, 2016

• #9

Thank ..vou try here

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 23, 2016

• #10

taking advantage of the post know why is giving this error ??
Error occurred on line: 82 (DBUtils)
java.lang.RuntimeException: Object should first be initialized.
line that is giving the error: SQL.BeginTransaction

 

Upvote 0

LucaMs

Expert

Licensed User

Longtime User

• Jan 23, 2016

• #11

MarcioCC said:

Object should first be initialized

Click to expand...

Read the error message: SQL is not initialized

 

Upvote 0

MarcioCC

Member

Licensed User

Longtime User

• Jan 23, 2016

• #12

how do I start SQL ??
It has an example

 

Upvote 0

imbault

Well-Known Member

Licensed User

Longtime User

• Jan 23, 2016

• #13

MarcioCC said:

how do I start SQL ??
It has an example

Click to expand...

Yes a lot

B4X:

Dim SQL1 As SQL
SQL1.Initialize(File.DirDefaultExternal, "smile.db", False)

 

Upvote 0