dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlBlob Class / SetLength Method
The size of the PgSqlBlob in bytes.
Example

SetLength Method (PgSqlBlob)
Sets length for PgSqlBlob value.
Syntax
'Declaration
 
Public Overrides Sub SetLength( _
   ByVal len As Long _
) 
 

Parameters

len
The size of the PgSqlBlob 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
PgSqlDataReader pictureReader = myCommand.ExecuteReader();
pictureReader.Read();
PgSqlBlob pictureBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"));
if (pictureBlob.Length > 100)
  pictureBlob.SetLength(100);
Dim pictureReader As PgSqlDataReader = myCommand.ExecuteReader
pictureReader.Read()
Dim pictureBlob As PgSqlBlob = pictureReader.GetPgSqlBlob(pictureReader.GetOrdinal("Picture"))
If (pictureBlob.Length > 100) Then
  pictureBlob.SetLength(CLng(100))
End If
See Also