Android Question db Blob needs a filename-Solved

[anOparator]

This code gives warnings but no errors and no file on the SD card. Would you tell me what's incorrect please.

Sub prnt2
Dim Cursor3 As Cursor = SQL1.ExecQuery("select image FROM MyTable WHERE name = name")
  Cursor3.Position = pos
  Dim Bmp As Bitmap             ' I added this
     If Cursor3.RowCount > pos Then
  Dim binImage() As Byte, Flux As InputStream
  binImage = Cursor3.GetBlob("Image")
  Flux.InitializeFromBytesArray(binImage, 0, binImage.Length)
  Bmp.Initialize2(Flux)
  Flux.Close
  End If
  Cursor3.Close
  Return Bmp         ' Warning Object converted to String
Dim out As OutputStream = File.OpenOutput(File.DirRootExternal, "0.png" , True)  ' Unreachable code
out.WriteBytes(binImage, 0, binImage.Length)
out.Cl
End Sub

Thanks for all pointers.

 

[Mahares]

This code gives warnings but no errors and no file on the SD card.

I think if you remove this line or comment it, you will be fine: Return Bmp
Also,
out.Cl should be out.Close, but I am pretty sure it is out.close in your code.

 

[anOparator]

Thanks , now I know I am reading the code well.

Yes it was out.Close yet I get same results with that line commented.
Here's my practice project.

 

[Erel]

You only need to initialize SQL when FirstTime is true.

How do you see that the file was not created?

 

[anOparator]

OK , I enable FirstTime True and it showed up once on Internal storage.

Using a MotoE from a AMD Phenom and not getting consistent results,

The file has never appeared on DirRootExternal.

Am going to run this on my old reliable laptop tomorrow. Thanks.

 

[Erel]

If you want to see the new file in Windows Explorer then you need to tell the OS to scan it: https://www.b4x.com/android/forum/threads/force-media-scanner-on-deleted-file.25794/#post-214985

 

[anOparator]

You only need to initialize SQL when FirstTime is true.
How do you see that the file was not created?

Thanks , I put a File Explorer on my no-service phone and see the files, in lieu of extra code for Windows Explorer.