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.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.webkit
gb.gui.trayicon
gb.gui.webview
gb.hash
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.mysql
_DataBase
_DataTypes
_Field
_Index
_MySQL
_Table
_User
_View
Connection
MySQL
DB
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.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
ar
ca
cs
de
en
eo
es
fa
fr
hu
id
it
ja
ko
mk
nl
pl
pt
pt_BR
ru
sq
tr
vi
zh
zh_TW
Connection (gb.mysql)
This class reimplements
Connection
in
gb.db
.
This class is
Creates a new connection object.
creatable
.
Properties
Methods
Returns the charset used by the database.
Charset
Return the list of collations available in the database
Collations
Returns a collection of all databases managed by the database server.
Databases
Returns the code of the last error raised by the database driver.
Error
Return the handle of the connection.
Handle
Returns or sets the host where the database server resides.
Host
Return or set if the database charset should be ignored.
IgnoreCharset
Return the value of the last serial field used in an INSERT statement.
LastInsertId
Returns or sets the user used for establishing the connection.
Login
The goal of
gb.mysql
is to create MySQL specific routines and then send them to the
gb.db
to be executed.
MySQL
Returns or sets the name of the database you want to connect to.
Name
Returns if the connection is opened.
Opened
Return or set the connection options.
Options
Returns or sets the password used for establishing the connection.
Password
Returns or sets the TCP/IP port used for establishing the connection.
Port
Returns a
sqlrequest
object on that connection.
SQL
Returns a virtual collection used for managing the tables of the database.
Tables
Return or set the connection timeout in seconds.
Timeout
Represents the type of the database server you want to connect to.
Type
Return the connection URL.
Url
A synonym for the
Login
property.
User
Returns a collection of all users registered in the database server.
Users
Returns the version of the database that the driver has connected to.
Version
Apply a template to the connection, i.e. replicate the database structure described by the template string into the current database.
ApplyTemplate
Start a transaction.
Begin
Close the connection.
Close
Commit a transaction.
Commit
Return a copy of the connection object.
Copy
Returns a read/write
Result
object used for creating records in the specified table.
Create
Removes records from a database table.
Delete
Returns a read/write
result
object used for editing records in the specified table.
Edit
Executes an arbitrary SQL request, and returns a read-only
Result
containing the result of the request.
Exec
Returns a read-only
Result
object used for querying records in the specified table.
Find
Format some blob data into a quoted string that can be inserted into a SQL query.
FormatBlob
Return the structure of the database as a template string.
GetTemplate
Limits the number of records returned by the next query.
Limit
Opens a connection to the specified database.
Open
Returns a quoted identifier so that you can freely insert it into a query.
Quote
Cancel a transaction.
Rollback
Creates a SQL sentence by substituting its arguments into a format string.
Subst