Cannot read blob field

[ThePuiu]

Hi,
I try to read a BLOB field from a local database. For this use the following code:

If mySQL.IsInitialized = False Then
mySQL.Initialize(File.DirInternal, "database.db3", False)
End If
Dim Cursor1 As Cursor   
Cursor1 = mySQL.ExecQuery("SELECT POZA FROM POZE WHERE id = (SELECT MIN(id) FROM poze)")    
Cursor1.Position = 0    
Dim Buffer() As Byte 
Buffer = Cursor1.GetBlob("POZA")   
Cursor1.Close()

but I get an error: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0 at line: Buffer = Cursor1.GetBlob("POZA").
Cursor1.ColumnCount and Cursor1.RowCount return correct value!
Can please someone tell me what am I doing wrong?
:sign0188:

 

[Mahares]

I created a project for your database, since you only included the database in the zip and used your code. But I copied the database to File.DirRootExternal instead of File.DirInternal and it worked fine for me. I did not get any error. It returned 1 record.
Also Cursor1.close() should be Cursor1.close, but that that is not the problem.

 

[ThePuiu]

Strange ... I did a small test project and used the exact same code and ... it works. With DirInternal and DirRootExternal!!! :BangHead:
I don't understand what is happening ...

 

[ThePuiu]

The mystery was solved! In my application was a subroutine called ReadBlob. After I renamed it, everything is back to normal!

Now I have another problem ... it is possible that due to the relatively large number of controls in a layout (20 edittext, 5 imageview, 1 webView and 12 buttons) application to move more slowly? The problem comes when I want to move a marker on the map ... it moves only a few millimeters, regardless of how I want it to move.

 

[Erel]

it moves only a few millimeters, regardless of how I want it to move.

It is not related to the other views.

Please start a new thread for this question and post the relevant code.