SetLength Method

In This Topic

Sets length for SQLiteBlob value.

Syntax

Visual Basic
C#

'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

csharp

SQLiteDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
SQLiteBlob pictureBlob = pictureReader.GetSQLiteBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);

Visual Basic

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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SQLiteBlob Class
SQLiteBlob Members
Length Property

Send Feedback