FileMaker(R) 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples

Introduction Welcome to FileMaker 9 Developer Reference . . . . . . . . . . . . . . . . . . . . . . . 1 Part I: FileMaker Specifications 1 FileMaker 9 Product Line . . . . . . . . . . . . . . . . . . . 9 2 New Features of FileMaker 9 . . . . . . . . . . . . . . . 13 3 Overview of FileMaker 8.5 Features . . . . . . . . . 21 4 Overview of FileMaker 8 Features . . . . . . . . . . . 25 5 Specifications and Storage Limits . . . . . . . . . . . 33 6 Field Types and Import/Export Formats . . . . . . 37 Part II: Calculation Functions 7 Calculation Primer . . . . . . . . . . . . . . . . . . . . . . . . 53 8 Calculation Signatures . . . . . . . . . . . . . . . . . . . . 59 9 Calculation Functions . . . . . . . . . . . . . . . . . . . . . 69 Part III: Custom Functions 10 Custom Function Primer . . . . . . . . . . . . . . . . . . 243 11 Useful Custom Functions . . . . . . . . . . . . . . . . . 249 Part IV: Script Steps 12 Scripting Primer . . . . . . . . . . . . . . . . . . . . . . . . . 331 13 Script Step Reference . . . . . . . . . . . . . . . . . . . . 337 Part V: FileMaker Connectivity 14 FileMaker XML Reference . . . . . . . . . . . . . . . . . 439 15 FileMaker API for PHP . . . . . . . . . . . . . . . . . . . . 453 16 JDBC/ODBC and External SQL Connectivity . . 489 17 AppleScript Integration . . . . . . . . . . . . . . . . . . . 499 Part VI: Quick Reference 18 FileMaker Error Codes . . . . . . . . . . . . . . . . . . . 511 19 FileMaker Keyboard Shortcuts . . . . . . . . . . . . . 521 20 FileMaker Network Ports . . . . . . . . . . . . . . . . . 539 21 FileMaker Server Command Line Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541 Part VII: Appendix A Additional Resources . . . . . . . . . . . . . . . . . . . . 553 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 561Bowers, Bob is the author of 'FileMaker(R) 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples', published 2007 under ISBN 9780789737083 and ISBN 0789737086.