List of Tutorials

Table 200 contains a list of the advanced tutorials, their related files, and a description of their content. Filenames containing the word out give the output of the tutorial program; filenames containing the word err contain error messages.

Table 200. The SourcePro DB advanced tutorials

Tutorial and Location

Related Files

Tutorial Description

Retrieving Data from a Table

t1
t1out.txt
t1err.txt

Demonstrates how to retrieve data from a table in a database and how to use an arbitrary struct or class

Retrieving Data Selectively

t2
t2out.txt
t2err.txt

Demonstrates selective retrieval of data from a table in a database

Inserting Data into a Table

t3
t3out.txt
t3err.txt

Demonstrates how to insert data into a table in a database

Inserting and Updating Data

t4
t4out.txt

t4err.txt

Demonstrates how to insert and update data in a database

Deleting Rows from a Table

t5
t5out.txt
t5err.txt

Demonstrates how to delete rows from a table in a database

A Complicated Query

t6
t6out.txt
t6err.txt

Demonstrates a complicated query with the entire result set brought directly into memory. Uses a template-based collection from the Essential Tools Module to store query data

Updating Data in Multiple Tables

t7
t7out.txt
t7err.txt

Demonstrates how to enter new data and update existing data in multiple tables within a database