DB Functions Library
A library of functions used to create, read, update, examine and delete database tables.
You can download this library here: DB Functions Library.ana
Supported Database Platforms
- SQL Server
- MariaDB
- PostgreSQL
- MS Access
User Functions
DB_Create_Table
Creates a new database table having column names of «field», data formats of «type», and optional null or non-null designation of «constraint».
DB_Delete_Table
Deletes an existing database table «tbl».
DB_Add_Column
Adds a new column «field» to an existing database table «tbl».
DB_Delete_Column
Deletes an existing column «field» from an existing database table «tbl».
DB_List_Tables
Lists all the table names from an existing database table referenced in the «connectStr».
DB_List_Columns
Lists all the column names in an existing database table «tbl».
DB_Add_Record
Adds a new record to database table «tbl». The field and value pairs of the new record are specified by the «field» and «value» parameters, respectively.
DB_Update_Record
Syntax to update the values in an existing record in database table «tbl». The field and updated value pairs are specified by the «updatedField» and «updatedValue» parameters, respectively. The existing record to be updated is found by searching for the field and value pairs specified by the «lookupField» and «lookupValue» parameters, respectively.
DB_Delete_Record
Deletes existing database records where column names «field» have entries of «value».
DB_Retrieve_Record
Retrieves columns «retrieveField» from an existing database table «tbl» for records where column names «lookupField» have entries of «lookupValue». Parameters «retrieveField», «lookupField» and «lookupValue» are optional. Omitting «retrieveField» will return all columns in the table. Omitting either «lookupField» or «lookupValue» will return all records in the table.
Examples Module
To quickly try out this library with a live test database, you can download this example module here: DB Library Demo.ana. This module will guide you through creating a table, inserting data, retrieving data, deleting data.
Supporting Additional DB Platforms
Advanced users who want to add syntax to support an additional DB platform can do this through the DB Syntax Definitions module. Add your platform to the DB Platforms index and your syntax to each of the provided syntax variables, then switch the selected DB Platform at the top of the library and test your syntax by making use of the debug parameter provided by each function.
Enable comment auto-refresher