Gambas Documentation
Documents

For Each Result (gb.db)

Dim hResult As Result
For Each hResult
  ...
Next

Enumerates all records in the Result object by moving its internal cursor. The order of the enumeration is predictable; such as in the case of using the "ORDER BY" clause.

Example

DIM Res AS Result

Res = DB.Exec("SELECT * FROM MyTable")

FOR EACH Res
  PRINT Res!Code; " "; Res!Name
NEXT