DB (gb.db)
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 of the connected database as a string.
|
Handle
|
Return the handle of the connection.
|
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.
|
Opened
|
Returns if the connection is opened.
|
Tables
|
Returns a virtual collection used for managing the tables of the database.
|
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.
|
FormatBlob
|
Format some blob data into a quoted string that can be inserted into a SQL query.
|
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.
|