ALM Site Administratation Client Type Library
Running an SQL query
Private Sub RunQuery()
'The following Visual Basic example runs an SQL statement
' showing the first 25 row results.
    Dim sDomainName As String
    Dim sProjectName As String
    Dim sSql As String
    Dim sReply As String

    On Error GoTo err
    sDomainName = "MyDomain"
    sProjectName = "MyProject"
    sSql = "SELECT * FROM REQ"

    sReply = m_SAClient.RunQuery _
        (sDomainName, sProjectName, sSql, 25, 0)

    MsgBox sReply
    Exit Sub
err:
    MsgBox "Program failed:" + err.Description
End Sub
Send documentation feedback to HP.