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   Return the value of the last serial field used in an INSERT statement. LastInsertId   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