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