Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Database Result Set Object |
The Database Object's execute_select() method will return variables of Database Result Set type. You can also create an empty Database Result Set object using the Database Object's get_empty_default_result_set() method.
A Database Result Set simply contains all the tuples (rows) returned from the executed query. The table below lists all the methods currently available on the Database Result Set object:
| Method | Description |
|---|---|
| add_row() | Adds a Result Set Row object into the result set and returns the Result Set Row so that it can be populated. |
| count_of_row() | Returns the number of rows in the result set. |
| value(RowIndex, ColumnIndexOrName) | Returns the value in the specified row under the specified column index or name. Row indexes start at 0 and go to count_of_row() - 1. Column indexes start at 0. |
For more information, see Database Object to view a detailed example on how to use the methods for the Database Result Set Object.