PureBasic - Database

Overview

The database library is an easy set of functions to access SQLite 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

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

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

CloseDatabase
DatabaseColumnName
DatabaseColumnType
DatabaseColumns
DatabaseDriverDescription
DatabaseDriverName
DatabaseError
DatabaseID
DatabaseQuery
DatabaseUpdate
ExamineDatabaseDrivers
FinishDatabaseQuery
FirstDatabaseRow
GetDatabaseDouble
GetDatabaseFloat
GetDatabaseLong
GetDatabaseQuad
GetDatabaseString
IsDatabase
NextDatabaseDriver
NextDatabaseRow
OpenDatabase
OpenDatabaseRequester
PreviousDatabaseRow
UseODBCDatabase
UseSQLiteDatabase

Example

Database.pb

Supported OS

All