Clarion Databases & SQL Book

Printer-friendly version

Clarion Databases & SQL is a softcover book containing selected articles on the subjects of databases and SQL from Clarion Magazine's first five years in publication. These articles were written for Clarion 5.0 and 5.5, but many are just as applicable to Clarion 6. Topics include database design concepts, TPS file techniques, introductory SQL, specific techniques for databases including MySQL, PostgreSQL, MS SQL, and Oracle (many of the concepts discussed are transferrable to other SQL databases), SQL book reviews, ABC core class design notes (by David Bayliss, the original author of these classes), and a collection of database tips and techniques.
Softcover, approx. 600 pages. Edited by David Harms.
CoveComm Inc. ISBN: 0-9689553-3-9

You can view the table of contents (PDF, 76k) online. If you have difficulty downloading the PDF please try right clicking on the link and choosing Save Target As (or equivalent).

Buy Now

Questions about Clarion Magazine's books? Read the FAQ

Source code

The source code for the Clarion Databases & SQL book is contained in the following zip file:

ClarionDatabasesAndSQL.zip (1.03 MB)

Errata

Corrections to the book will be posted here as necessary.

  • On page 68, in the listings of the fields for the three tables, the field in the DoesTrick file called DoesSysID should TrickSysID.

 

 

Clarion Roadmap

Try the roadmap (beta)

Search ClarionMag

 

Advanced search

From the archives

A Callback Technique for Capesoft's FileManager2

12/21/2006 12:00:00 AM

CapeSoft's FileManager2, and its more recent incarnation FileManager3, are amazing products: they completely automate the process of upgrading client databases, whether local or across a network, and make it easy to do file maintenance. Randy Rogers shows how to add a callback procedure to FM2 to provide user feedback during startup.