Programming 4th Dimension Contents

These are the sections, chapters, and page numbers for Programming 4th Dimension. You can also download a more detailed PDF version (364 K.)

Introduction

About This Book
3
4D V6 for 4D 3.x Users
11

Structure

Normalization
21
Field Types
31
Subtables
37
Fat Tables
41
Indexes
45
About Relations
47
Using Relations
51
BLOBs
57

Selections

Address Tables
69
Sets
73
Managing Selections
79
Optimizing Queries
87
Sorting
97
RELATE ONE SELECTION and
RELATE MANY SELECTION
105
SCAN INDEX and
REDUCE SELECTION
111
ARRAY TO SELECTION
113
SELECTION TO ARRAY
119

Interface

Input Forms
125
Output Forms and Subforms
135
User Perception
143
Startup Speed
149

Programming

Compile Your Database
157
Case Statements
165
Parameters
171
Loops
177
Arrays
183
Strings
189
Pointers
199
EXECUTE
211
Error Handling
217
Database Methods
223

Development

Programming Style
231
Optimization Overview
241
Compiler Methods
245
Testing
253

Processes

About Processes
261
Local Processes
269
Stored Procedures
273
Hidden Global Processes
285
General Purpose Processes
289

4D Server

4D Server Optimization Principles
297
Record Locking
301
Object Locking Using Semaphores
307
4D Server Based Commands
313
Server Executed Code
319
Transactions
325
Batch Workstations
333

Summary Data

About Summary Data
339
Compound Fields
341
Summary Fields
345
Summary Tables
349
Saved Sets
357

Data Accuracy

About Data Accuracy
367
Perfect Accuracy
371
Periodic Accuracy
383
Close Enough Accuracy
393
Committing a Record
397
Triggers
401

Printing

About Printing
413
Avoiding Printing
417
PRINT SELECTION
421
PRINT FORM
427

Caches

Caches Introduction
433
About Caches
435
4D Client Caches
441
Local Caches
449
Server Caches
463

Alternative Connections

Alternative Connection Types
469
4D Remote
473
4D Open
477
Web Clients
483
Email Interfaces
493

Background

4D Gotchas
503
Resources
513
Plug-ins
533

Code Libraries

Batch Workstation
539
Error Manager
549
General Code Library
557
Free Join
575
Initialization Manager
579
Set Manager
595
Transaction Manager
607