ADO SetEOS Method (Stream object)

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 


ADO Stream object: SetEOS
Method

This method sets the value of the EOS property to be the current position.

The SetEOS method is used to set the current position to be the end of the stream (EOS). If any data exists beyond the newly set EOS, it will be truncated and permanently lost.

Remember that you can use the Position property to set the position in the data. Also, the CopyTo, Write, and WriteText properties do not truncate.

Note: Any data beyond the new EOS will be truncated and lost.

Syntax

objStream.SetEOS

Example

If (objStream.EOS = false) Then
   objStream.SetEOS = objStream.Position
End If