comp • gb.db • db

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.

Static properties

Static methods Constants
Returns the charset used by the database.
Charset  
Return the list of collations available in the database
Collations  
Returns or sets the current connection.
Current  
Returns a collection of all databases managed by the database server.
Databases  
Sets or returns if the database component is in debugging mode.
Debug  
Returns the code of the last error raised by the database driver.
Error  
Return the handle of the connection.
Handle  
Return or set if the database charset should be ignored.
IgnoreCharset  
Returns if the connection is opened.
Opened  
Returns a virtual collection used for managing the tables of the database.
Tables  
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  
Start a transaction.
Begin  
Close the connection.
Close  
Commit a transaction.
Commit  
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  
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  
This constant represents a Blob field datatype.
Blob  
Represents a Boolean field datatype.
Boolean  
This constant represents a Date field datatype.
Date  
This constant represents a Float field datatype.
Float  
This constant represents an Integer field datatype.
Integer  
This constant represents a Long field datatype.
Long  
This constant represents a Serial field datatype.
Serial  
This constant represents a String field datatype.
String