PSCommandClass

Provides a mechanism for storing and re-executing a SQL statement. You must assign a variable of the PSCommandClass type before you can create an instance of the object or call methods on it.

Syntax

PSCommandClass ( strSql, conn)

Constructors

PSCommandClass constructor	Datatype	Description
strSql	String	SQL statement you want to execute
conn	PSConnectionClass	Object you use to connect to the database where you want to execute the SQL statement

Methods

PSCommandClass method	Description
Execute	Executes a SQL command
SetSQL	Obsolete method that was previously used for PowerDynamo or ASP targets