SpiderBasic - Database

Overview

The database library is an easy set of functions to access and create databases. For now, it only allows to access client side database in the SQLite format. 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

Command Index

AffectedDatabaseRows
CheckDatabaseNull
CloseDatabase
DatabaseColumnIndex
DatabaseColumnName
DatabaseColumns
DatabaseError
DatabaseID
DatabaseQuery
DatabaseUpdate
ExportDatabase
ExportDatabaseMemory
FinishDatabaseQuery
FirstDatabaseRow
GetDatabaseBlob
GetDatabaseDouble
GetDatabaseFloat
GetDatabaseLong
GetDatabaseQuad
GetDatabaseString
IsDatabase
NextDatabaseRow
OpenDatabase
SetDatabaseBlob
SetDatabaseDouble
SetDatabaseFloat
SetDatabaseLong
SetDatabaseNull
SetDatabaseQuad
SetDatabaseString

Example

Database.sb
DatabasePersistent.sb
Reference Manual - Index