GAMBAS BOOK 3.19.5

The Result class represents, among other things, the result of an SQL query:

• The class cannot be created.
• This class behaves like a read/write array.
• This class can be enumerated with the keyword FOR EACH.

Examples

  Dim hResult As Result
  Dim vVariant As Variant

  vVariant = hResult [ Fieldname As String ] oder
  vVariant = hResult!Fieldname

The last two statements each return the value of a field with the specified field name in the current data record of the result object.

Result cursor

The result object is a cursor as a view of a restricted set of rows that results from the execution of the query by the DBMS. The cursor may or may not “lock” rows and tables in the database, depending on how it was executed. This lock allows only one user at a time to make guaranteed updates to the data in the database. This is a fundamental approach in the theory of DB management systems. In the DB world of Gambas, this cursor is described as read-only and read/write. Different methods for returning results from the Connection class return different cursor types: Create → Read/Write, Edit →Read/Write, Exec →Read Only and Find →ReadOnly.

The Result class has these properties:

Table 22.4.10.1.1 : Properties of the Result class

The Result class has these methods:

Table 22.4.10.2.1 : Methods of the Result class

This class describes all fields in a Result. The Result.Fields.Count property (data type Integer) returns the number of data records in the result of a database query.

The class has these two methods:

Table 22.4.10.4.1 : Methods of the Result.Fields class