ALM Site Administratation Client Type Library
RunQuery Method
DomainName
The domain name.

ProjectName
The project name.

SqlQuery
The SQL statement.

MaxRecords
The maximum number of records to return.

FromRecord

Return records from this record to the end of the record set.  For example, if FromRecord is 8, records 0 to 7 are not returned. All records from the ninth (index = 8) on are returned.

Description

Runs the SQL statement on the project database and retrieves results.

Syntax

Visual Basic
Public Function RunQuery( _
   ByVal DomainName As String, _
   ByVal ProjectName As String, _
   ByVal SqlQuery As String, _
   ByVal MaxRecords As Long, _
   ByVal FromRecord As Long _
) As String

Parameters

DomainName
The domain name.

ProjectName
The project name.

SqlQuery
The SQL statement.

MaxRecords
The maximum number of records to return.

FromRecord

Return records from this record to the end of the record set.  For example, if FromRecord is 8, records 0 to 7 are not returned. All records from the ninth (index = 8) on are returned.

Return Type

On success, returns an XML string containing selected records according to the SQL statement. ColumnLables show all columns, numbers, and names. DataRows show all the rows that return results. For each row that returns results, only the columns containing data are returned.

Example

See Also

Send documentation feedback to HP.