CHSDK Class Descriptions › CaWSQL › Execute Method

Execute Method

Executes the SQL statement supplied by SetSQLStatement against the CA Harvest SCM database.

Syntax

object.Execute()

Owning Class

CaWSQL

Arguments

None

Return Value

A long - Zero if success. Nonzero if failure.

Example

Dim objSQL
Set objSQL = objContext.GetSQL()
objSQL.SetSQLStatement(“Select * from HARUSER”)
 objSQL.Execute(); CaContainer sqldata = rSQL.GetSQLResult();
Set objContainer = objSQL.GetSQLResult();

More information:

• CHSDK Programming Fundamentals
• CaWContext