Gambas Documentation
Application Repository
Code Snippets
Compilation & Installation
Components
gb
gb.args
gb.cairo
gb.chart
gb.clipper
gb.complex
gb.compress
gb.crypt
gb.data
gb.db
gb.db.form
gb.db.mysql
gb.db.odbc
gb.db.postgresql
gb.db.sqlite2
gb.db.sqlite3
gb.db2
_ConnectionDatabases
_ConnectionTables
_ConnectionUsers
_TableFields
_TableIndexes
Connection
Connections
Database
DatabaseUser
DB
Field
Index
Result
_get
_next
_put
All
Available
Connection
Count
Delete
Editable
Fields
Index
Length
Max
MoveFirst
MoveLast
MoveNext
MovePrevious
MoveTo
Reset
Update
ResultField
SQLRequest
Table
gb.dbus
gb.dbus.trayicon
gb.debug
gb.desktop
gb.desktop.gnome.keyring
gb.desktop.x11
gb.eval
gb.eval.highlight
gb.form
gb.form.dialog
gb.form.editor
gb.form.htmlview
gb.form.mdi
gb.form.print
gb.form.stock
gb.form.terminal
gb.gmp
gb.gsl
gb.gtk
gb.gtk.opengl
gb.gtk3
gb.gtk3.opengl
gb.gtk3.webview
gb.gui
gb.gui.opengl
gb.gui.qt
gb.gui.qt.ext
gb.gui.qt.opengl
gb.gui.qt.webkit
gb.gui.trayicon
gb.gui.webview
gb.hash
gb.highlight
gb.image
gb.image.effect
gb.image.imlib
gb.image.io
gb.inotify
gb.jit
gb.libxml
gb.logging
gb.map
gb.markdown
gb.media
gb.media.form
gb.memcached
gb.mime
gb.mongodb
gb.mysql
gb.ncurses
gb.net
gb.net.curl
gb.net.pop3
gb.net.smtp
gb.openal
gb.opengl
gb.opengl.glsl
gb.opengl.glu
gb.opengl.sge
gb.openssl
gb.option
gb.pcre
gb.pdf
gb.poppler
gb.qt4
gb.qt4.ext
gb.qt4.opengl
gb.qt4.webkit
gb.qt4.webview
gb.qt5
gb.qt5.ext
gb.qt5.opengl
gb.qt5.webkit
gb.qt5.webview
gb.qt6
gb.qt6.ext
gb.qt6.opengl
gb.qt6.webview
gb.report
gb.report2
gb.scanner
gb.sdl
gb.sdl.sound
gb.sdl2
gb.sdl2.audio
gb.settings
gb.signal
gb.term
gb.test
gb.util
gb.util.web
gb.v4l
gb.vb
gb.web
gb.web.feed
gb.web.form
gb.web.gui
gb.xml
gb.xml.html
gb.xml.rpc
gb.xml.xslt
Controls pictures
Deprecated components
Developer Documentation
Development Environment Documentation
Documents
Error Messages
Gambas Playground
How To's
Language Index
Language Overviews
Last Changes
Lexicon
README
Search the wiki
To Do
Topics
Tutorials
Wiki License
Wiki Manual

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   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   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.

Method Result Type
create Editable
edit Editable
exec Read-only
find Read-only