Syntax

Execute(ExecuteCommand, RecordsAffected [, TimeOut] [, Options])

Return value

Type

Description

ADODB.Recordset

Read-only, Forward-Only

Parameter

Use

Name

Type

Passing

Description

Required

ExecuteCommand

String

ByVal

Command string

Required

RecordsAffected

Long

ByRef

Number of records affected

Optional

TimeOut

Long

ByVal

Waiting time to cancel connection attempt (default 0 - infinity)

Optional

Options

ExecuteOptions

ByVal

Type of command

ConnectionStates

Description

1 – EO_CmdText

TextDescription of a command (e.g. SQL statement)

1 – EO_CmdTable

Table name

512 – EO_CmdTableDirect

Direct table name

4 – EO_CmdStoredProcedure

Stored Procedure

256 – EO_CmdFile

File

8 – EO_CmdUnknown

Unknown

-1 – EO_All

Provider examines the command sequence independently