Our classic 600+ page book on managing Clarion databases and working with SQL is now available for download as a PDF e-book!
This is for your personal use as a subscriber of Clarion Magazine.
Table of Contents
Introduction to Databases
- Designing Databases 1
- Handling Many-To-Many Relationships 9
- Managing Complexity, Rule 1: Eliminate Repeating Fields 21
- Managing Complexity, Rule 2: Eliminate Redundant Data 29
- Managing Complexity, Rule 3: Eliminate Columns That Don’t Belong 39
- Managing Complexity, Rule 4: Isolate Independent Multiple Relationships 45
- Managing Complexity, Rule 5: Isolate Semantically Related Multiple Relationships 49
- Displaying Normalized Data 55
- Displaying Many-To-Many Relationships 67
- True Confessions: A Tale of Two Users 85
Using Topspeed Files
- Using Dynamic Indexes With TPS Files 91
- Using The TPS ODBC Driver 97
- Reading Tables With ADO 103
- Accessing TPS Files Via ASP 109
- Using Example Files With TPSFix 117
- Topspeed Driver Error Codes 119
- Troubleshooting TPS File Corruption 125
- Resolving Network And Other File Problems 129
General SQL
- An Introduction To SQL 141
- Getting Into SQL On The Cheap 167
- How To Convert Your Database To SQL 175
- Converting TPS To MS-SQL 183
- Avoid My SQL Mistakes! 197
- SQL Data Types Comparison 201
- The SQL Answer Cowboy 209
Open Source SQL
- Using Clarion With MySQL 221
- MySQL/MyODBC Notes 241
- MySQL: InnoDB Tables And Transactions 247
- Large Table Performance in MySQL 265
- Getting Started With PostgreSQL 273
Oracle
- Referential Integrity In Oracle 295
- AutoNumbering In Oracle 299
- Transactions In Oracle 305
MS SQL
- Migrating The Inventory Application To SQL Server 317
- Using SQL Server’s Data Transformation Services 341
- Converting Data With Linked Servers 357
- Converting The Inventory Example - Calling Stored Procedures 371
- SQL Identity: Another Approach 399
- Creating Utilities For MS SQL 2000 405
- Generating MS SQL Server Side Triggers 415
- Date Filtering with MS SQL 429
Book Reviews
- Book Review: PostgreSQL Developer’s Handbook 435
- Book Review: SQL Tuning 437
- Book Review: SQL In A Nutshell 441
- Book Review: Managing & Using MySQL 443
ABC Database Class Design Notes
- Inside ABC: FieldPairsClass and BufferedPairsClass 447
- Inside ABC: The FileManager 459
- Inside ABC: The RelationManager 483
- Inside ABC: The ViewManager 495
Database Tips & Techniques
- Clarion File Access Basics 507
- Managing Table Opens In ABC 517
- Creating ODBC Data Sources At Runtime 527
- Securing Remote Database Connections With SSH Tunneling 535
- Using Client-Side Triggers In Clarion 6 543
- Working With Control Files 547
- Changing Dictionaries 563
- Alias - Who Was That Masked File? 567
- Propitious Memory Corruption 577
- Detecting Duplicate Records 585
- NAME() Comes Of Age 591
Appendices
- Appendix A: Getting Support 601
- Appendix B: Related Articles 603
- Author Index 605
- Index 609