SQLiteBLOB.EndOfFile
From Xojo Documentation
Method
Indicates the end of the data has been reached when reading data from the BLOB.
Example
This example reads the Logo (stored as a binary picture) from the Logo column for rowID = 1 in the Team table:
Var blob As SQLiteBlob
blob = db.OpenBlob("Team", "Logo", 1, True)
If blob <> Nil Then
Try
Var data As String
While Not blob.EndOfFile
data = data + blob.Read(1000)
Wend
blob.Close
// Do something with the data
Catch error As IOException
MessageBox("Error while reading BLOB: " + error.Message
End Try
End If
blob = db.OpenBlob("Team", "Logo", 1, True)
If blob <> Nil Then
Try
Var data As String
While Not blob.EndOfFile
data = data + blob.Read(1000)
Wend
blob.Close
// Do something with the data
Catch error As IOException
MessageBox("Error while reading BLOB: " + error.Message
End Try
End If