dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteBlob Class / SetLength Method
The size of the SQLiteBlob in bytes.
Example

On this page
    SetLength Method
    On this page
    Sets length for SQLiteBlob value.
    Syntax
    'Declaration
 
Public Overrides Sub SetLength( _
   ByVal len As Long _
) 
    public override void SetLength( 
   long len
)

    Parameters

    len
    The size of the SQLiteBlob in bytes.
    Remarks
    If the given value is less than the current length of the stream, the stream is truncated. If the given value is larger than the current length of the stream, the stream is expanded. If the stream is expanded, the contents of the stream between the old and the new length are undefined.
    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

    Reference

    SQLiteBlob Class
    SQLiteBlob Members
    Length Property

     

     

    © 2008 - 2026 Devart. All Rights Reserved.

    Send Feedback