PureBasic - Database

Overview

The database library is an easy set of commands to access any database type (Oracle, MySQL, Access, etc..) using the common ODBC API. The library is based on SQL queries to get/set data in a Database, so it could be interesting to have a quick look to a SQL description document if needed.

Here are some links about SQL syntax:
W3Schools SQL Tutorial
SQLite SQL Commands

You start the database programming with initializing the database enviroment using InitDatabase().

Command Index

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

Example

Database.pb

Supported OS

Windows, Linux, MacOS X