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
Begin
Blob
Boolean
Charset
Close
Collations
Commit
Create
Current
Databases
Date
Debug
Delete
Edit
Error
Exec
Find
Float
FullVersion
Handle
Host
IgnoreCharset
Integer
LastInsertId
Limit
Login
Long
Name
Open
Opened
Password
Port
Quote
Rollback
Serial
String
Subst
Tables
Timeout
Type
User
Users
Version
Field
Index
Result
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

DB (gb.db2)

This class represents the current connection.

The current connection is by default the first opened database. You can modify it by using the Current property.

This class is static.

Constants
Blob   This constant represents a blob field datatype.
Boolean   Represents a Boolean field datatype.
Date   This constant represents a Date field datatype.
Float   This constant represents a Float field datatype.
Integer   This constant represents an Integer field datatype.
Long   This constant represents a Long field datatype.
Serial   This constant represents a Serial field datatype.
String   This constant represents a String field datatype.

Static properties
Charset   Returns the charset used by the database.
Collations   Return the list of collations available in the database
Current   Returns or sets the current connection.
Databases   Returns a collection of all databases managed by the database server.
Debug   Sets or returns if the database component is in debugging mode.
Error   Returns the code of the last error raised by the database driver.
FullVersion   Return the full version string of the database server.
Handle   Return the handle of the connection.
Host   Returns or sets the host where the database server resides.
IgnoreCharset   Return or set if the database charset should be ignored.
LastInsertId   Return the value of the last serial field used in an INSERT statement.
Login   Returns or sets the user used for establishing the connection.
Name   Returns or sets the name of the database you want to connect to.
Opened   Returns if the connection is opened.
Password   Returns or sets the password used for establishing the connection.
Port   Returns or sets the TCP/IP port used for establishing the connection.
Tables   Returns a virtual collection used for managing the tables of the database.
Timeout   Return or set the connection timeout in seconds.
Type   Represents the type of the database server you want to connect to.
User   A synonym for the Login property.
Users   Returns a collection of all users registered in the database server.
Version   Returns the version of the database that the driver has connected to.

Static methods
Begin   Start a transaction.
Close   Close the connection.
Commit   Commit a transaction.
Create   Return a read/write Result object used for creating records in the specified table.
Delete   Removes records from a database table.
Edit   Returns a read/write Result object used for editing records in the specified table.
Exec   Executes an arbitrary SQL request, and returns a read-only Result containing the result of the request.
Find   Returns a read-only Result object used for querying records in the specified table.
Limit   Limits the number of records returned by the next query.
Open   Opens a connection to the specified database.
Quote   Returns a quoted identifier so that you can freely insert it into a query.
Rollback   Cancel a transaction.
Subst   Creates a SQL sentence by substituting its arguments into a format string.