ADO: ActiveX Data Objects

Name

Command.CommandStream Property — (Version 2.6)

Synopsis

                     Command.CommandStream = Stream
                  

The CommandStream property sets or returns the data provider-specific stream that is used as the Command’s input just as the CommandText property identifies the command to use as the input.

Datatype

Variant

Description

The CommandStream property is used to specify the stream used as a Command’s input. If this property is set, then the CommandText property is set to an empty String (“”). Similarly, if the CommandText property is set, the CommandStream property is set to Nothing.

If a Command object whose source is a stream is used to create a Recordset object, reading the Recordset object’s Source property would return an empty String (“”), because it returns the value of the Command object’s CommandText property.

You must use either the adCmdText or adCmdUnknown enumeration values for the CommandType property if the CommandStream property is set.

The format of the stream being set to the CommandStream property is data provider-specific, as is the behavior of both the Command.Parameters.Refresh and Command.Prepare methods.

See Also

Command.CommandText Property, Comand.CommandDialect Property, CommandTypeEnum Enumeration, Recordset.Source