| Introduction Welcome to FileMaker 9 Developer Reference |
|
1 | (1) |
|
|
|
1 | (1) |
|
How This Book Is Organized |
|
|
2 | (7) |
|
I. FileMaker Specifications |
|
|
|
|
|
9 | (4) |
|
Overview of FileMaker Products |
|
|
9 | (4) |
|
|
|
9 | (1) |
|
|
|
9 | (1) |
|
|
|
10 | (1) |
|
FileMaker Server 9 Advanced |
|
|
10 | (3) |
|
New Features of FileMaker 9 |
|
|
13 | (8) |
|
|
|
13 | (5) |
|
|
|
13 | (1) |
|
Auto Resize Layout Objects |
|
|
14 | (1) |
|
External SQL Data Sources |
|
|
15 | (1) |
|
|
|
16 | (1) |
|
|
|
17 | (1) |
|
|
|
18 | (3) |
|
Running ScriptMaker Scripts |
|
|
18 | (3) |
|
Overview of FileMaker 8.5 Features |
|
|
21 | (4) |
|
|
|
21 | (4) |
|
|
|
21 | (1) |
|
|
|
22 | (1) |
|
|
|
23 | (1) |
|
FileMaker Learning Center |
|
|
23 | (1) |
|
Support for Intel-Based Macs |
|
|
23 | (2) |
|
Overview of FileMaker 8 Features |
|
|
25 | (8) |
|
|
|
25 | (6) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
26 | (1) |
|
New Field Control Options |
|
|
26 | (1) |
|
Go to Related Record by Found Set |
|
|
27 | (1) |
|
|
|
27 | (1) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
Date and Time Range Shorthand Searching |
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
29 | (1) |
|
Relationships Graph Enhancements |
|
|
30 | (1) |
|
New Calculation Functions |
|
|
30 | (1) |
|
|
|
31 | (2) |
|
|
|
31 | (1) |
|
|
|
31 | (1) |
|
|
|
32 | (1) |
|
Copying and Pasting Schema Objects |
|
|
32 | (1) |
|
Specifications and Storage Limits |
|
|
33 | (4) |
|
|
|
33 | (2) |
|
External SQL Sources (ESS) Specifications |
|
|
35 | (2) |
|
Field Types and Import/Export Formats |
|
|
37 | (16) |
|
|
|
37 | (1) |
|
|
|
38 | (5) |
|
|
|
38 | (1) |
|
|
|
39 | (1) |
|
|
|
39 | (1) |
|
|
|
40 | (1) |
|
|
|
41 | (1) |
|
|
|
42 | (1) |
|
|
|
42 | (1) |
|
|
|
43 | (1) |
|
Additional ESS References |
|
|
43 | (1) |
|
|
|
43 | (4) |
|
|
|
43 | (2) |
|
Importing Multiple Files at Once |
|
|
45 | (1) |
|
Importing from an ODBC Data Source |
|
|
46 | (1) |
|
Importing from an XML-based Data Source |
|
|
47 | (1) |
|
Creating New Tables on Import |
|
|
47 | (1) |
|
|
|
47 | (6) |
|
|
|
48 | (1) |
|
Exporting to FileMaker Pro |
|
|
48 | (1) |
|
|
|
48 | (1) |
|
Automatically Opening or Emailing Exported Files |
|
|
49 | (4) |
|
II. Calculation Functions |
|
|
|
|
|
53 | (6) |
|
The Calculation Function Interface |
|
|
53 | (6) |
|
Calculations: Things to Remember |
|
|
54 | (5) |
|
|
|
59 | (10) |
|
|
|
59 | (1) |
|
|
|
59 | (1) |
|
|
|
60 | (1) |
|
|
|
61 | (1) |
|
|
|
61 | (1) |
|
|
|
61 | (3) |
|
|
|
64 | (1) |
|
|
|
64 | (1) |
|
|
|
65 | (1) |
|
|
|
65 | (1) |
|
|
|
65 | (2) |
|
Text Formatting Functions |
|
|
67 | (1) |
|
|
|
67 | (1) |
|
|
|
68 | (1) |
|
|
|
68 | (1) |
|
|
|
69 | (174) |
|
|
|
|
|
|
243 | (6) |
|
The Custom Function Interface |
|
|
244 | (5) |
|
Custom Functions: Things to Remember |
|
|
244 | (5) |
|
|
|
249 | (82) |
|
Sample Custom Function Library |
|
|
249 | (1) |
|
|
|
249 | (6) |
|
|
|
255 | (4) |
|
Text and Data Conversions |
|
|
259 | (17) |
|
|
|
276 | (2) |
|
|
|
278 | (8) |
|
|
|
286 | (4) |
|
|
|
290 | (2) |
|
Toolkit for Complex Data Structures |
|
|
292 | (19) |
|
Data API Within FileMaker |
|
|
292 | (1) |
|
|
|
293 | (1) |
|
Using XML as a Data Structure |
|
|
293 | (1) |
|
|
|
294 | (3) |
|
|
|
297 | (14) |
|
Storing (and Unstoring) Text Data as CSS |
|
|
311 | (20) |
|
|
|
312 | (1) |
|
|
|
313 | (18) |
|
|
|
|
|
|
331 | (6) |
|
About FileMaker Scripting |
|
|
331 | (6) |
|
The ScriptMaker Interface |
|
|
331 | (1) |
|
|
|
331 | (2) |
|
|
|
333 | (1) |
|
|
|
333 | (1) |
|
|
|
333 | (1) |
|
|
|
334 | (1) |
|
|
|
335 | (2) |
|
|
|
337 | (102) |
|
About the Script Step Reference |
|
|
337 | (102) |
|
V. FileMaker Connectivity |
|
|
|
|
|
439 | (14) |
|
|
|
439 | (1) |
|
URL Syntax for Web Access to FileMaker Data |
|
|
439 | (2) |
|
URL Syntax for XML Access |
|
|
440 | (1) |
|
URL Syntax for Access to Container Objects |
|
|
440 | (1) |
|
URL Syntax for XSLT Access |
|
|
441 | (1) |
|
|
|
441 | (5) |
|
Query Parameters for XML/XSLT URL Requests |
|
|
446 | (5) |
|
|
|
447 | (1) |
|
|
|
448 | (3) |
|
FileMaker XML and XSLT Namespaces |
|
|
451 | (2) |
|
|
|
453 | (36) |
|
About the FileMaker API for PHP |
|
|
453 | (1) |
|
|
|
453 | (1) |
|
|
|
454 | (35) |
|
|
|
454 | (7) |
|
|
|
461 | (2) |
|
|
|
463 | (1) |
|
FileMaker_Command_CompoundFind |
|
|
464 | (1) |
|
|
|
465 | (1) |
|
FileMaker_Command_Duplicate |
|
|
465 | (1) |
|
|
|
465 | (2) |
|
|
|
467 | (2) |
|
FileMaker_Command_FindAll |
|
|
469 | (1) |
|
FileMaker_Command_FindAny |
|
|
469 | (1) |
|
FileMaker_Command_FindRequest |
|
|
469 | (1) |
|
FileMaker_Command_PerformScript |
|
|
470 | (1) |
|
|
|
470 | (1) |
|
FileMaker_Error_Validation |
|
|
471 | (2) |
|
|
|
473 | (5) |
|
|
|
478 | (3) |
|
|
|
481 | (4) |
|
|
|
485 | (1) |
|
|
|
486 | (3) |
|
JDBC/ODBC and External SQL Connectivity |
|
|
489 | (10) |
|
About SQL-Based Data Exchange |
|
|
489 | (1) |
|
Setting Up Inbound ODBC and JDBC Connectivity |
|
|
489 | (2) |
|
Configuring a Database for ODBC/JDBC Access |
|
|
489 | (1) |
|
Enabling ODBC/JDBC Access in FileMaker Pro |
|
|
490 | (1) |
|
Enabling ODBC/JDBC Access in FileMaker Server Advanced |
|
|
491 | (1) |
|
Setting Up a DSN for External SQL Connectivity |
|
|
491 | (8) |
|
Setting Up a DSN for the Mac OS |
|
|
492 | (2) |
|
Setting Up a DSN in Windows |
|
|
494 | (3) |
|
Using an External Data Source from Within FileMaker |
|
|
497 | (2) |
|
|
|
499 | (12) |
|
Understanding AppleScript |
|
|
499 | (2) |
|
The AppleScript Interface |
|
|
501 | (2) |
|
About the AppleScript Object Model |
|
|
503 | (2) |
|
Understanding the Application Dictionary |
|
|
505 | (2) |
|
|
|
507 | (1) |
|
|
|
508 | (3) |
|
|
|
|
|
|
511 | (10) |
|
|
|
511 | (10) |
|
FileMaker Keyboard Shortcuts |
|
|
521 | (18) |
|
Working Quickly, Saving Time |
|
|
521 | (1) |
|
Essential Shortcuts by Group |
|
|
522 | (6) |
|
|
|
522 | (1) |
|
|
|
523 | (1) |
|
Data Entry and Formatting |
|
|
524 | (1) |
|
|
|
524 | (1) |
|
Working with the Relationships Graph |
|
|
525 | (1) |
|
|
|
526 | (1) |
|
|
|
527 | (1) |
|
Navigating the FileMaker Interface |
|
|
528 | (1) |
|
|
|
528 | (11) |
|
|
|
528 | (1) |
|
FileMaker Pro/Advanced Menu (Mac OS Only) |
|
|
529 | (1) |
|
|
|
530 | (1) |
|
|
|
530 | (1) |
|
|
|
531 | (2) |
|
|
|
533 | (1) |
|
Layouts Menu (Layout Mode Only) |
|
|
534 | (1) |
|
|
|
535 | (1) |
|
Requests Menu (Find Mode Only) |
|
|
535 | (1) |
|
Arrange Menu (Layout Mode Only) |
|
|
536 | (1) |
|
|
|
536 | (1) |
|
Tools Menu (FileMaker Pro Advanced Only) |
|
|
537 | (1) |
|
|
|
537 | (1) |
|
|
|
538 | (1) |
|
|
|
539 | (2) |
|
|
|
539 | (2) |
|
FileMaker Server Command Line Reference |
|
|
541 | (12) |
|
Administering FileMaker Server from the Command Line |
|
|
541 | (1) |
|
FileMaker Server Command Line Reference |
|
|
542 | (11) |
|
|
|
|
|
|
553 | (8) |
|
General Information on Relational Databases |
|
|
553 | (1) |
|
Data Modeling and Database Design |
|
|
553 | (1) |
|
Project Management, Programming, and Software Development |
|
|
554 | (1) |
|
Running a FileMaker Consulting Practice |
|
|
554 | (1) |
|
General Resources for Tips and Tricks |
|
|
555 | (1) |
|
Hosting FileMaker Databases on the Web |
|
|
556 | (1) |
|
|
|
556 | (1) |
|
|
|
556 | (2) |
|
|
|
558 | (1) |
|
|
|
558 | (1) |
|
|
|
559 | (1) |
|
|
|
559 | (1) |
|
|
|
560 | (1) |
| Index |
|
561 | |