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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access