Stream

The ADO Stream object provides access to a stream of binary data or text. By access, we mean the ability to read, write, and manage the stream.

For example, you can use the Record and Recordset objects to gain access to files on a Web server, and then use the Stream object to gain access and manipulate the actual contents of those files.

There are three major ways to obtain a Stream object: From a URL pointing to a file, folder, or a Record object. By instantiating a Stream object to store data for your application. By opening the default Stream object associated with a Record

Properties

Charset	Sets or returns a string value that specifies into which character set the contents of a text Stream are to be translated.
EOS	Returns a Boolean value indicating whether or not the current position is at the end of the stream.
LineSeparator	Sets or returns a LineSeparatorEnum value that specifies which binary character to use as the line separator in a text Stream object.
Mode	Sets or returns a ConnectModeEnum value that specifies the available permissions for modifying data.
Position	Sets or returns a long value that specifies the current position, measured in bytes, from the beginning of the stream.
Size	Returns a long value that is the size in bytes of an opened Stream object.
State	Returns a long value describing if the Stream object is open or closed.
Type	Sets or returns a StreamTypeEnum value defining if the data is binary or text.

Methods

Cancel	Cancels the execution of a pending Open call.
Close	Close a Stream object.
CopyTo	Copies the specified number of characters or bytes from one Stream object to another Stream object.
Flush	Sends the contents of the Stream object to the underlying object that is the source of the Stream object.
LoadFromFile	Loads the contents of an existing file into an open Stream object.
Open	Opens a Stream object from a URL or Record object.
Read	Reads the specified number of bytes from a binary Stream object andreturns the data as a variant.
ReadText	Reads the specified number of bytes from a text Stream object andreturns the data as a string.
SaveToFile	Copies (saves) the contents of an opened Stream object to a specified file.
SetEOS	Sets the value of the EOS property to be the current position.
SkipLine	Skips all of the characters on one entire line, including the next line separator, while reading a text stream.
Write	Writes a specified number of bytes of binary data to an opened Stream object without adding any intervening spaces.
WriteText	Writes a specified text string to an opened Stream object without adding any intervening spaces or characters.