Command Object Execute Method PROPERTY:  Command::CommandType commandobject.CommandType = CommandTypeEnum CommandTypeEnum = commandobject.CommandType   The CommandType property sets or returns a CommandTypeEnum constant that defines the type of the Command object.   The default is adCmdUnknown. If the specific type declared using the CommandType property does not match the actual type of the Command object, an error will be generated when the Execute method is called.   If you do not specify the type, ADO will need to contact the provider to determine the type of the command. In contrast, if you do specify the type, ADO will usually be able to process the command faster. This is a very simple, yet expedient way to optimize submitting a Command against a data source.   You may also combine the adExecuteNoRecords constant from the ExecuteOptionEnum constants with the adCmdText or adCmdStoredProc constants of the CommandTypeEnum constants to speed up processing.   CommandTypeEnum Constants   Constant Value Description adCmdFile 256 Evaluate as a previously persisted file adCmdStoredProc 4 Evaluate as a stored procedure adCmdTable 2 Have the provider generate a SQL query and return all rows from the specified table adCmdTableDirect 512 Return all rows from the specified table adCmdText 1 Evaluate as a textual definition adCmdUnknown 8 The type of the CommandText parameter is unknown adCmdUnspecified -1 Default, does not specify how to evaluate   ExecuteOptionEnum Constants   Constant Value Description adExecuteNoRecords 0x80 Does not return rows and must be combined with adCmdText or adCmdStoredProc   Code (VBScript): Set objCommand = Server.CreateObject("ADODB.Command") Set objCommand.ActiveConnection = strConnection objCommand.CommandType = adCmdText OR adExecuteNoRecords Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information