Runs the SQL statement on the project database and retrieves results.
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 |
- 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.
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.