Gambas/libraries/gb.db/Connection

About

The Connection class provides an interface to a particular database engine connection. It is similar to the Connection interface in ADO.

Usage

To connect to a database server: create a connection object, fill the needed properties, and call the Open method.

For SQLite connections, the following algorithm is used:

• If Name is null, then a memory database is opened.
• If Name is an absolute path, then this path is used.
• If Name is a relative path, then:
  • If Host is null, then the database is located in the application temporary directory, which is /tmp/gambas.$UID/sqlite .
  • Otherwise, Host gives the database directory, and the database path is the result of concatenating Host and Name.

This class is creatable:

DIM hConnection AS Connection
hConnection = NEW Connection ( ) 

Identifiers

Properties	Methods
Charset() AS String (r) Databases AS .ConnectionDatabases Host AS String Login AS String Name AS String Password AS String Port AS String Tables AS .ConnectionTables Type AS String Users AS .ConnectionUsers Version AS Integer (r)	Begin() Close() Commit() Create( Table AS String ) AS Result Edit( Table AS String REDIRECT Template:arg/opt ) AS Result Exec( Request AS String, Arguments AS REDIRECT Template:fmt/arg/opt ) AS Result Find( Table AS String [ <, Request AS String, Arguments AS , ...> ] ) AS Result Open() AS Boolean Quote( Name AS String ) AS String Rollback()

Links

Reference

• Gambas Documentation