Gambas/libraries/gb.db/Connection

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< Gambas‎ | libraries‎ | gb.db
Revision as of 22:04, 5 December 2006 by Woozle (talk | contribs) (→‎Navigation: navbar tweak)
Jump to navigation Jump to search

Navigation

computing: software: programming: Gambas: gb.db.Connection

Overview

The gb.db.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
  1. REDIRECT Template:arg/opt ) AS Result
  • Exec( Request AS String, Arguments AS
  1. 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()