Database programming guide

This part provides guidance and reference for programmers building database applications. The sections below outline the documentation for VA Smalltalk and VA Smalltalk Base database classes:

•	Database basics

•	Accessing database management systems

•	Creating and deleting databases and tables

•	Querying databases

•	Base database reference

•

IBM CLI

•	ODBC database reference

•	Oracle database reference

 

Running examples with SQLite

SQLite support is available on all VA Smalltalk platforms. The SQLite runtime executables are also shipped with VA Smalltalk and are included in every client installation. To get started with SQLite, install the ST: Database, SQLite feature.

If you would like to run the example code in this section of the document with SQLite, you need to create the SAMPLE database in a SQLite format before running them. The SAMPLE database setup code is included in the SQLite Testing feature. Follow these steps to create the database:

 

1.	Install the ST: Database, SQLite Testing feature

2.	Open a workspace and execute the following code snippet. This will create a SQLite database file named SAMPLE in the current working directory:

| connection |

connection := (AbtDatabaseConnectionSpec forDbmClass: AbtSQLiteDatabaseManager databaseName: 'SAMPLE') connect.

AbtSQLiteTestCase new createSampleDatabaseUsing: connection.

connection disconnect.