Clarion Databases & SQL Book
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
DoesTrickfile calledDoesSysIDshouldTrickSysID.
Talk To Us!
Search ClarionMag
From the archives
Improving On The Non-Related Lookup Template
7/17/2006 12:00:00 AM
Clarion ships with a template that allows you to do a lookup from a table that is not related to the primary table. While very useful, it offers room for improvement, as Nardus Swanevelder demonstrates.
