dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteBlob Class / Length Property
Example

Length Property (SQLiteBlob)
Gets the size of the SQLiteBlob.
Syntax
'Declaration
 
Public Overrides ReadOnly Property Length As Long
 

Property Value

The size of the SQLiteBlob in bytes.
Remarks
The size of the SQLiteBlob is always returned in bytes for all data types.
Example
SQLiteDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
SQLiteBlob pictureBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);
Dim pictureReader As SQLiteDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As SQLiteBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If
See Also