PureBasic - Database

Overview

The database library is an easy set of functions to access SQLite, PostgreSQL or any database type (Oracle, MySQL, Access, etc) via ODBC. Accessing and updating data is done using SQL queries, therefore it is necessary to have an understanding of SQL syntax.

Here are some links about SQL syntax:
W3Schools SQL Tutorial
SQLite SQL functions
PostgreSQL manual

Database programming starts by initializing the database environment using UseODBCDatabase(), UseSQLiteDatabase(), and UsePostgreSQLDatabase().

Note: Under Windows, prior to using an ODBC database, it is necessary to establish an ODBC "User Data Source" which makes your database available via ODBC and useable with this Database library. For more information, refer to Windows's ODBC help document.

Command Index

AffectedDatabaseRows
CheckDatabaseNull
CloseDatabase
DatabaseColumnIndex
DatabaseColumnName
DatabaseColumnSize
DatabaseColumnType
DatabaseColumns
DatabaseDriverDescription
DatabaseDriverName
DatabaseError
DatabaseID
DatabaseQuery
DatabaseUpdate
ExamineDatabaseDrivers
FinishDatabaseQuery
FirstDatabaseRow
GetDatabaseBlob
GetDatabaseDouble
GetDatabaseFloat
GetDatabaseLong
GetDatabaseQuad
GetDatabaseString
IsDatabase
NextDatabaseDriver
NextDatabaseRow
OpenDatabase
OpenDatabaseRequester
PreviousDatabaseRow
SetDatabaseBlob
SetDatabaseDouble
SetDatabaseFloat
SetDatabaseLong
SetDatabaseNull
SetDatabaseQuad
SetDatabaseString
UseODBCDatabase
UsePostgreSQLDatabase
UseSQLiteDatabase

Example

Database.pb

Supported OS

All