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, ColumnName)	Returns the value in the specified row under the specified column name. Row indexes start at 0 and go to count_of_row() - 1.

For more information, see Database Object to view a detailed example on how to use the methods for the Database Result Set Object.

iNTERFACEWARE™ Inc.

Database Result Set Object