Android Question ERROR READING BLOB IMAGE DATABASE SQLITE !!

[MarcioCC]

good night, insert a picture in my database SQLite now want to read the image, more ta giving the following error when I run the app: android.database.sqlite.SQLiteException: no such column: name (code 1):, while compiling: SELECT * FROM WHERE name = TBFILMES?
The error is giving this line: Cursor1 = s.ExecQuery2 ("SELECT PHOTO FROM TBFILMES WHERE name =?" Array As String (""))
What am I doing wrong??

 

[LucaMs]

no such column: name

TBFILMES has not a column named "name"

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

 

[MarcioCC]

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

 

[MarcioCC]

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

 

[LucaMs]

Check Cursor1.RowCount and set cursor position

 

[LucaMs]

("FOTO" or "PHOTO"?)

 

[MarcioCC]

FOTO

 

[mangojack]

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

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

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

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 ..

 

[MarcioCC]

Thank ..vou try here

 

[MarcioCC]

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

 

[LucaMs]

Object should first be initialized

Read the error message: SQL is not initialized

 

[MarcioCC]

how do I start SQL ??
It has an example

 

[imbault]

how do I start SQL ??
It has an example

Yes a lot

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