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.

Konstanty

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.