code:data:sql
This is an old revision of the document!
Table of Contents
Sql
This object allows you to establish a connection to a SQL database like MySQL, PostgreSQL, SQLite and others.
Functions
Sql
Constructor function.
Syntax
var myObject = new Sql(driver);
Arguments
- driver - (Driver) the database driver to use
Exceptions
- (NoDatabaseDriverError) no database driver specified
Example
Create a Sql object operating on a MySQL database.
var myObject = new Sql(Sql.MySQL);
Notes
On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default. To see all available drivers call the drivers function.
Enumerations
Driver
SQL drivers. On Windows only the MySQL, PostgreSQL, SQLite 3, Firebird and ODBC drivers are installed by default.
Values
- SQLite2: SQLite 2
- SQLite: SQLite 3
- PostgreSQL: PostgreSQL (versions 7.3 and above)
- MySQL: MySQL
- ODBC: Open Database Connectivity (ODBC) - Microsoft SQL Server and other ODBC-compliant databases
- InterBase: Borland InterBase (Firebird)
- OCI: Oracle Call Interface Driver
- TDS: Sybase Adaptive Server (obsolete)
- DB2: IBM DB2 (version 7.1 and above)
code/data/sql.1296068298.txt.gz · Last modified: 2021/02/13 11:23 (external edit)