Result (gb.db2)

This class represents the result of a SQL request.

This class is creatable.

This class acts like a read / write array.

This class is enumerable with the FOR EACH keyword.

Properties

Available	Returns True if the result object contains one or more accessible database rows.
Connection	Returns the parent connection object.
Count	Returns the number of rows in the query result.
Editable	Since 3.18 Return if the result is editable.
Fields	Return a collection of all result fields.
Index	Returns the index of the current record, starting from zero.
Length	This is a synonymous for the Count property.
Max	Returns Result.Count - 1 (and so it returns `-1` if there is no record).

Methods

All	Since 3.11 Return the value of the specified field of each result record as an array.
Delete	Deletes the current record.
MoveFirst	Moves to the first record of the result.
MoveLast	Moves to the last record of the result.
MoveNext	Moves to the next record of the result.
MovePrevious	Moves to the previous record of the result.
MoveTo	Moves to a specified record.
Reset	Undo any change done to a result created by the Create or Connection method.
Update	Updates the current record into the database, if this record has been modified and if the Result is a writable cursor.

Result objects are not database cursors, but a copy of database records. And so they are not synchronized with successive database changes.

There are two types of result objects, depending on the method used for creating them.