• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Understanding Universal Data... > Using the ADODB.Command Object

Using the ADODB.Command Object

The Command object is analogous to RDO's rdoQuery object. The primary purpose of the Command object is to execute parameterized stored procedures, either in the form of the default temporary prepared statements or persistent, precompiled SQL statements. MSDE and SQL Server create temporary prepared statements exist only for the lifetime of the current client connection. Precompiled SQL statements are procedures stored in the database file; their more common name is stored procedure. When creating Recordsets from SQL statements, the more efficient approach is to bypass the Command object and use the Recordset.Open method.

Command Properties

The Command object has relatively few properties, many of which duplicate those of the Connection object. Table 27.9 lists the names and descriptions of the Command object's properties. Like the Connection object, the Command object has its own provider-specific Properties collection, described in the "Properties Collection of the Command Object" section later in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint