June 2001
Intermediate to advanced
620 pages
19h 29m
English
Content preview from ADO: ActiveX Data ObjectsBecome 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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
Command.CommandText Property — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Command.CommandText = CommandText
The CommandText property sets or returns a valid SQL statement, table name, stored procedure name, relative URL, or any other command text that the data provider may recognize.
Datatype
String
Description
The CommandText property contains a String value that by default contains a zero-length string (“”). This string can be set to a SQL statement, table name, stored procedure call, relative URL, or any other command text that the data provider may recognize.
The CommandType property is used to indicate to ADO what type of
information resides within the CommandText property. If the
CommandType property is set to adCmdText, it
indicates to the provider that the CommandText property value
contains a text command that the provider will understand. This will
usually be a SQL statement, but not necessarily.
If you set the CommandText property, ADO prepares the specified query
on the Execute or Open methods whenever the Prepared property of the
Command object is set to True, and it is bound to
an open connection.
The value of CommandText may be changed by ADO, depending on the value of the CommandType property. Retrieve the value of the CommandText property at any time if you question its value.
If the CommandStream property is set to a value, then the CommandText property is automatically set to an empty string (“”).
See Also
Command.CommandStream, Command.CommandType Property, Command.Dialect ...
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
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.