Gambas/libraries/gb.db/Connection - Revision history

Woozle: updating links to use subpages

2013-04-24T20:24:39Z

updating links to use subpages

← Older revision		Revision as of 20:24, 24 April 2013
Line 1:		Line 1:
	==~~Navigation~~==		==About==
	~~[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference~~\|~~reference]]: [[gb.db]].'''Connection'''~~		The {{l/same\|Connection}} class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].

	~~==Overview==~~
	~~The [[gb.db.~~Connection]] class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].
	==Usage==		==Usage==
	To connect to a database server: create a connection object, fill the needed properties, and call the Open method.		To connect to a database server: create a connection object, fill the needed properties, and call the Open method.
Line 25:		Line 22:
	\|-		\|-
	\| valign=top \|		\| valign=top \|
	* ~~[[Charset (gb.db.Connection)~~\|Charset]]() AS String [[read-only property\|(r)]]		* {{l/sub\|Charset}}() AS String [[read-only property\|(r)]]
	* ~~[[Databases (gb.db.Connection)~~\|Databases]] AS ~~[[.ConnectionDatabases (gb.db)~~\|.ConnectionDatabases]]		* {{l/sub\|Databases}} AS {{l/same\|.ConnectionDatabases}}
	* ~~[[Host (gb.db.Connection)~~\|Host]] AS String		* {{l/sub\|Host}} AS String
	* ~~[[Login (gb.db.Connection)~~\|Login]] AS String		* {{l/sub\|Login}} AS String
	* ~~[[Name (gb.db.Connection)~~\|Name]] AS String		* {{l/sub\|Name}} AS String
	* ~~[[Password (gb.db.Connection)~~\|Password]] AS String		* {{l/sub\|Password}} AS String
	* ~~[[Port (gb.db.Connection)~~\|Port]] AS String		* {{l/sub\|Port}} AS String
	* ~~[[Tables (gb.db.Connection)~~\|Tables]] AS ~~[[.ConnectionTables (gb.db)~~\|.ConnectionTables]]		* {{l/sub\|Tables}} AS {{l/same\|.ConnectionTables}}
	* ~~[[Type (gb.db.Connection)~~\|Type]] AS String		* {{l/sub\|Type}} AS String
	* ~~[[Users (gb.db.Connection)~~\|Users]] AS ~~[[.ConnectionUsers (gb.db)~~\|.ConnectionUsers]]		* {{l/sub\|Users}} AS {{l/same\|.ConnectionUsers}}
	* ~~[[Version (gb.db.Connection)~~\|Version]] AS Integer [[read-only property\|(r)]]		* {{l/sub\|Version}} AS Integer [[read-only property\|(r)]]
	\| valign=top \|		\| valign=top \|
	* ~~[[Begin (gb.db.Connection)~~\|Begin]]()		* {{l/sub\|Begin}}()
	* ~~[[Close (gb.db.Connection)~~\|Close]]()		* {{l/sub\|Close}}()
	* ~~[[Commit (gb.db.Connection)~~\|Commit]]()		* {{l/sub\|Commit}}()
	* ~~[[Create (gb.db.Connection)~~\|Create]]( <u>Table</u> AS String ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Create}}( <u>Table</u> AS String ) AS {{l/same\|Result}}
	* ~~[[Edit (gb.db.Connection)~~\|Edit]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Edit}}( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS {{l/same\|Result}}
	* ~~[[Exec (gb.db.Connection)~~\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Exec}}( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS {{l/same\|Result}}
	* ~~[[Find (gb.db.Connection)~~\|Find]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Find}}( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS {{l/same\|Result}}
	* ~~[[Open (gb.db.Connection)~~\|Open]]() AS Boolean		* {{l/sub\|Open}}() AS Boolean
	* ~~[[Quote (gb.db.Connection)~~\|Quote]]( <u>Name</u> AS String ) AS String		* {{l/sub\|Quote}}( <u>Name</u> AS String ) AS String
	* ~~[[Rollback (gb.db.Connection)~~\|Rollback]]()		* {{l/sub\|Rollback}}()
	\|}		\|}
	==Links==		==Links==
	===Reference===		===Reference===
	* [http://gambasdoc.org/help/comp/gb.db/connection Gambas Documentation]		* [http://gambasdoc.org/help/comp/gb.db/connection Gambas Documentation]

Woozle: Woozle moved page gb.db.Connection to Gambas/libraries/gb.db/Connection: reorganizing

2013-04-24T20:12:08Z

Woozle moved page gb.db.Connection to Gambas/libraries/gb.db/Connection: reorganizing

← Older revision	Revision as of 20:12, 24 April 2013
(No difference)

Woozle: /* Identifiers */ links - reference - Gambas doc

2008-01-05T14:18:00Z

Identifiers: links - reference - Gambas doc

← Older revision		Revision as of 14:18, 5 January 2008
Line 48:		Line 48:
	* [[Rollback (gb.db.Connection)\|Rollback]]()		* [[Rollback (gb.db.Connection)\|Rollback]]()
	\|}		\|}
			==Links==
			===Reference===
			* [http://gambasdoc.org/help/comp/gb.db/connection Gambas Documentation]

Woozle: /* Navigation */ added "reference"

2006-12-05T22:13:27Z

Navigation: added "reference"

← Older revision		Revision as of 22:13, 5 December 2006
Line 1:		Line 1:
	==Navigation==		==Navigation==
	[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].'''Connection'''		[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference\|reference]]: [[gb.db]].'''Connection'''

	==Overview==		==Overview==

Woozle: /* Navigation */ navbar tweak

2006-12-05T22:04:30Z

Navigation: navbar tweak

← Older revision		Revision as of 22:04, 5 December 2006
Line 1:		Line 1:
	==Navigation==		==Navigation==
	[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].[[Connection ~~(gb.db)\|Connection]]~~		[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].'''Connection'''

	==Overview==		==Overview==
	The [[gb.db.Connection]] class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].		The [[gb.db.Connection]] class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].

Woozle: /* Identifiers */ formatting tweaks

2006-12-05T16:31:47Z

Identifiers: formatting tweaks

← Older revision		Revision as of 16:31, 5 December 2006
Line 40:		Line 40:
	* [[Commit (gb.db.Connection)\|Commit]]()		* [[Commit (gb.db.Connection)\|Commit]]()
	* [[Create (gb.db.Connection)\|Create]]( <u>Table</u> AS String ) AS [[Result (gb.db)\|Result]]		* [[Create (gb.db.Connection)\|Create]]( <u>Table</u> AS String ) AS [[Result (gb.db)\|Result]]
	* [[Edit (gb.db.Connection)\|Edit]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]		* [[Edit (gb.db.Connection)\|Edit]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Exec (gb.db.Connection)\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS [[Result (gb.db)\|Result]]		* [[Exec (gb.db.Connection)\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Find (gb.db.Connection)\|Find]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]		* [[Find (gb.db.Connection)\|Find]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Open (gb.db.Connection)\|Open]]() AS Boolean		* [[Open (gb.db.Connection)\|Open]]() AS Boolean
	* [[Quote (gb.db.Connection)\|Quote]]( <u>Name</u> AS String ) AS String		* [[Quote (gb.db.Connection)\|Quote]]( <u>Name</u> AS String ) AS String
	* [[Rollback (gb.db.Connection)\|Rollback]]()		* [[Rollback (gb.db.Connection)\|Rollback]]()
	\|}		\|}

Woozle: /* Identifiers */ more information

2006-12-05T15:50:49Z

Identifiers: more information

Woozle at 14:57, 5 December 2006

2006-12-05T14:57:48Z

New page

==Navigation==
[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[gb.db]].[[Connection (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 (Microsoft)|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 class|creatable]]:

DIM hConnection AS Connection
hConnection = NEW Connection ( )

==Identifiers==
{|
|-
! Properties || Methods
|-
| valign=top |
* [[Charset (gb.db.Connection)|Charset]]
* [[Databases (gb.db.Connection)|Databases]]
* [[Host (gb.db.Connection)|Host]]
* [[Login (gb.db.Connection)|Login]]
* [[Name (gb.db.Connection)|Name]]
* [[Password (gb.db.Connection)|Password]]
* [[Port (gb.db.Connection)|Port]]
* [[Tables (gb.db.Connection)|Tables]]
* [[Type (gb.db.Connection)|Type]]
* [[Users (gb.db.Connection)|Users]]
* [[Version (gb.db.Connection)|Version]]
| valign=top |
* [[Begin (gb.db.Connection)|Begin]]
* [[Close (gb.db.Connection)|Close]]
* [[Commit (gb.db.Connection)|Commit]]
* [[Create (gb.db.Connection)|Create]]
* [[Edit (gb.db.Connection)|Edit]]
* [[Exec (gb.db.Connection)|Exec]]
* [[Find (gb.db.Connection)|Find]]
* [[Open (gb.db.Connection)|Open]]
* [[Quote (gb.db.Connection)|Quote]]
* [[Rollback (gb.db.Connection)|Rollback]]
|}

← Older revision		Revision as of 20:24, 24 April 2013
Line 1:		Line 1:
	==~~Navigation~~==		==About==
	~~[[computing]]: [[software]]: [[programming]]: [[Gambas]]: [[Gambas reference~~\|~~reference]]: [[gb.db]].'''Connection'''~~		The {{l/same\|Connection}} class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].

	~~==Overview==~~
	~~The [[gb.db.~~Connection]] class provides an interface to a particular [[database engine]] connection. It is similar to the Connection interface in [[ADO (Microsoft)\|ADO]].
	==Usage==		==Usage==
	To connect to a database server: create a connection object, fill the needed properties, and call the Open method.		To connect to a database server: create a connection object, fill the needed properties, and call the Open method.
Line 25:		Line 22:
	\|-		\|-
	\| valign=top \|		\| valign=top \|
	* ~~[[Charset (gb.db.Connection)~~\|Charset]]() AS String [[read-only property\|(r)]]		* {{l/sub\|Charset}}() AS String [[read-only property\|(r)]]
	* ~~[[Databases (gb.db.Connection)~~\|Databases]] AS ~~[[.ConnectionDatabases (gb.db)~~\|.ConnectionDatabases]]		* {{l/sub\|Databases}} AS {{l/same\|.ConnectionDatabases}}
	* ~~[[Host (gb.db.Connection)~~\|Host]] AS String		* {{l/sub\|Host}} AS String
	* ~~[[Login (gb.db.Connection)~~\|Login]] AS String		* {{l/sub\|Login}} AS String
	* ~~[[Name (gb.db.Connection)~~\|Name]] AS String		* {{l/sub\|Name}} AS String
	* ~~[[Password (gb.db.Connection)~~\|Password]] AS String		* {{l/sub\|Password}} AS String
	* ~~[[Port (gb.db.Connection)~~\|Port]] AS String		* {{l/sub\|Port}} AS String
	* ~~[[Tables (gb.db.Connection)~~\|Tables]] AS ~~[[.ConnectionTables (gb.db)~~\|.ConnectionTables]]		* {{l/sub\|Tables}} AS {{l/same\|.ConnectionTables}}
	* ~~[[Type (gb.db.Connection)~~\|Type]] AS String		* {{l/sub\|Type}} AS String
	* ~~[[Users (gb.db.Connection)~~\|Users]] AS ~~[[.ConnectionUsers (gb.db)~~\|.ConnectionUsers]]		* {{l/sub\|Users}} AS {{l/same\|.ConnectionUsers}}
	* ~~[[Version (gb.db.Connection)~~\|Version]] AS Integer [[read-only property\|(r)]]		* {{l/sub\|Version}} AS Integer [[read-only property\|(r)]]
	\| valign=top \|		\| valign=top \|
	* ~~[[Begin (gb.db.Connection)~~\|Begin]]()		* {{l/sub\|Begin}}()
	* ~~[[Close (gb.db.Connection)~~\|Close]]()		* {{l/sub\|Close}}()
	* ~~[[Commit (gb.db.Connection)~~\|Commit]]()		* {{l/sub\|Commit}}()
	* ~~[[Create (gb.db.Connection)~~\|Create]]( <u>Table</u> AS String ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Create}}( <u>Table</u> AS String ) AS {{l/same\|Result}}
	* ~~[[Edit (gb.db.Connection)~~\|Edit]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Edit}}( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS {{l/same\|Result}}
	* ~~[[Exec (gb.db.Connection)~~\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Exec}}( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS {{l/same\|Result}}
	* ~~[[Find (gb.db.Connection)~~\|Find]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS ~~[[Result (gb.db)~~\|Result]]		* {{l/sub\|Find}}( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS {{l/same\|Result}}
	* ~~[[Open (gb.db.Connection)~~\|Open]]() AS Boolean		* {{l/sub\|Open}}() AS Boolean
	* ~~[[Quote (gb.db.Connection)~~\|Quote]]( <u>Name</u> AS String ) AS String		* {{l/sub\|Quote}}( <u>Name</u> AS String ) AS String
	* ~~[[Rollback (gb.db.Connection)~~\|Rollback]]()		* {{l/sub\|Rollback}}()
	\|}		\|}
	==Links==		==Links==
	===Reference===		===Reference===
	* [http://gambasdoc.org/help/comp/gb.db/connection Gambas Documentation]		* [http://gambasdoc.org/help/comp/gb.db/connection Gambas Documentation]

← Older revision		Revision as of 16:31, 5 December 2006
Line 40:		Line 40:
	* [[Commit (gb.db.Connection)\|Commit]]()		* [[Commit (gb.db.Connection)\|Commit]]()
	* [[Create (gb.db.Connection)\|Create]]( <u>Table</u> AS String ) AS [[Result (gb.db)\|Result]]		* [[Create (gb.db.Connection)\|Create]]( <u>Table</u> AS String ) AS [[Result (gb.db)\|Result]]
	* [[Edit (gb.db.Connection)\|Edit]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]		* [[Edit (gb.db.Connection)\|Edit]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Exec (gb.db.Connection)\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS [[Result (gb.db)\|Result]]		* [[Exec (gb.db.Connection)\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Find (gb.db.Connection)\|Find]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]		* [[Find (gb.db.Connection)\|Find]]( <u>Table</u> AS String {{optargs\|, <u>Request</u> AS String, <u>Arguments</u> AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Open (gb.db.Connection)\|Open]]() AS Boolean		* [[Open (gb.db.Connection)\|Open]]() AS Boolean
	* [[Quote (gb.db.Connection)\|Quote]]( <u>Name</u> AS String ) AS String		* [[Quote (gb.db.Connection)\|Quote]]( <u>Name</u> AS String ) AS String
	* [[Rollback (gb.db.Connection)\|Rollback]]()		* [[Rollback (gb.db.Connection)\|Rollback]]()
	\|}		\|}

← Older revision		Revision as of 15:50, 5 December 2006
Line 24:		Line 24:
	\|-		\|-
	\| valign=top \|		\| valign=top \|
	* [[Charset (gb.db.Connection)\|Charset]]		* [[Charset (gb.db.Connection)\|Charset]]() AS String [[read-only property\|(r)]]
	* [[Databases (gb.db.Connection)\|Databases]]		* [[Databases (gb.db.Connection)\|Databases]] AS [[.ConnectionDatabases (gb.db)\|.ConnectionDatabases]]
	* [[Host (gb.db.Connection)\|Host]]		* [[Host (gb.db.Connection)\|Host]] AS String
	* [[Login (gb.db.Connection)\|Login]]		* [[Login (gb.db.Connection)\|Login]] AS String
	* [[Name (gb.db.Connection)\|Name]]		* [[Name (gb.db.Connection)\|Name]] AS String
	* [[Password (gb.db.Connection)\|Password]]		* [[Password (gb.db.Connection)\|Password]] AS String
	* [[Port (gb.db.Connection)\|Port]]		* [[Port (gb.db.Connection)\|Port]] AS String
	* [[Tables (gb.db.Connection)\|Tables]]		* [[Tables (gb.db.Connection)\|Tables]] AS [[.ConnectionTables (gb.db)\|.ConnectionTables]]
	* [[Type (gb.db.Connection)\|Type]]		* [[Type (gb.db.Connection)\|Type]] AS String
	* [[Users (gb.db.Connection)\|Users]]		* [[Users (gb.db.Connection)\|Users]] AS [[.ConnectionUsers (gb.db)\|.ConnectionUsers]]
	* [[Version (gb.db.Connection)\|Version]]		* [[Version (gb.db.Connection)\|Version]] AS Integer [[read-only property\|(r)]]
	\| valign=top \|		\| valign=top \|
	* [[Begin (gb.db.Connection)\|Begin]]		* [[Begin (gb.db.Connection)\|Begin]]()
	* [[Close (gb.db.Connection)\|Close]]		* [[Close (gb.db.Connection)\|Close]]()
	* [[Commit (gb.db.Connection)\|Commit]]		* [[Commit (gb.db.Connection)\|Commit]]()
	* [[Create (gb.db.Connection)\|Create]]		* [[Create (gb.db.Connection)\|Create]]( <u>Table</u> AS String ) AS [[Result (gb.db)\|Result]]
	* [[Edit (gb.db.Connection)\|Edit]]		* [[Edit (gb.db.Connection)\|Edit]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Exec (gb.db.Connection)\|Exec]]		* [[Exec (gb.db.Connection)\|Exec]]( <u>Request</u> AS String, Arguments AS {{optargs\|, ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Find (gb.db.Connection)\|Find]]		* [[Find (gb.db.Connection)\|Find]]( <u>Table</u> AS String {{optargs\|, Request AS String, Arguments AS , ...}} ) AS [[Result (gb.db)\|Result]]
	* [[Open (gb.db.Connection)\|Open]]		* [[Open (gb.db.Connection)\|Open]]() AS Boolean
	* [[Quote (gb.db.Connection)\|Quote]]		* [[Quote (gb.db.Connection)\|Quote]]( <u>Name</u> AS String ) AS String
	* [[Rollback (gb.db.Connection)\|Rollback]]		* [[Rollback (gb.db.Connection)\|Rollback]]()
	\|}		\|}