Clarion Databases & SQL

Front Cover
David Gerhard Harms
CoveComm Inc., 2004 - Clarion for Windows (Computer program language) - 624 pages
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Designing Databases
1
Handling ManyToMany Relationships
9
Eliminate Repeating Fields
21
Eliminate Redundant Data
29
Eliminate Columns That Dont Belong
39
Isolate Independent Multiple Relationships
45
Displaying Normalized Data
55
Displaying ManyToMany Relationships
67
Oracle
295
Migrating The Inventory Application To SQL Server
317
Using SQL Servers Data Transformation Services
341
Converting Data With Linked Servers
357
Converting The Inventory Example Calling Stored Procedures
371
Another Approach
399
Creating Utilities For MS SQL 2000
405
Generating MS SQL Server Side Triggers
415

A Tale of Two Users
85
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 17
121
Resolving Network And Other File Problems
129
An Introduction To SQL
141
Getting Into SQL On The Cheap
167
How To Convert Your Database To SQL
175
Converting TPS To MSSQL
183
Avoid MySQL Mistakes
197
The SQL Answer Cowboy
209
Using Clarion With MySQL
221
MySQLMyODBC Notes
241
InnoDB Tables And Transactions
247
Large Table Performance in MySQL
265
Getting Started With PostgreSQL
273
Date Filtering with MS SQL
429
PostgreSQL Developers Handbook
435
SQL In A Nutshell
441
FieldPairsClass and BufferedPairsClass
447
The FileManager
459
The RelationManager
483
The ViewManager
495
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 ClientSide Triggers In Clarion 6
543
Changing Dictionaries
563
Propitious Memory Corruption
577
Detecting Duplicate Records
585
NAMEO Comes Of Age
591
Getting Support
601
Copyright

Common terms and phrases

About the author (2004)

David Harms is an author and consultant with over ten years' experience developing applications for the broadcast industry and the educational sector. His work as a software developer, conference speaker, and course instructor has taken him around the world. Harms is the founder and President of CoveComm Inc., which specializes in electronic publishing using Java technology.

Bibliographic information