did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780789737083

FileMaker 9 Developer Reference Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples

by ; ;
  • ISBN13:

    9780789737083

  • ISBN10:

    0789737086

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2007-08-02
  • Publisher: Que Publishing
  • View Upgraded Edition
  • Purchase Benefits
List Price: $39.99 Save up to $8.50
  • Digital
    $31.49
    Add to Cart

    DURATION
    PRICE

Supplemental Materials

What is included with this book?

Summary

Maybe you know FileMaker, and you have used it for years, but need a quick reference, immediately accessible while not interrupting your work on screen. This is the only book on the market expressly focused on describing each calculation formula and how and when to use each! Filled with real-world, concrete examples, this book is an invaluable companion to readers working to develop solutions to their every day software problems. Contains hundreds of calculation functions, script steps, and operations that will appeal to every FileMaker user, new and old.

Author Biography

Bob Bowers, CEO of Soliant Consulting, is a columnist and contributing editor for

FileMaker Advisor magazine and has coauthored five books: Advanced FileMaker Pro 5.5

Techniques for Developers, Advanced FileMaker Pro 6 Web Development, Special Edition Using

FileMaker 7, Special Edition Using FileMaker 8, and FileMaker 8 Functions and Scripts Desk

Reference. At the 2002 FileMaker Developer Conference he was awarded the FileMaker

Fellowship Award. Widely recognized as one of the leading educators for database and

FileMaker Pro technologies, he is authorized by FileMaker, Inc., to teach the Professional

Training Foundation Series. Bob is also a proud dad of two young children, an avid musician,

a die-hard Cubs fan, and an accomplished woodworker.

 

Steve Lane, vice president of Soliant Consulting, served as a special projects developer at

Scott Foresman, a leading K-6 Educational publisher. He has written for FileMaker Advisor

magazine, and coauthored four books: Advanced FileMaker Pro 6 Web Development, Special

Edition Using FileMaker Pro 7, Special Edition Using FileMaker 8, and FileMaker 8 Functions

and Scripts Desk Reference. He has led training classes in FileMaker technologies all over the

country and is also authorized to teach the Professional Training Foundation Series. He

regularly speaks at the annual FileMaker Developer Conference where in 2003 he was

awarded the FileMaker Fellowship Award for “pushing the boundaries of FileMaker Pro.”

When not writing about technology, Steve is likely to be found being chased about by his

children, or grumbling over the fingerings of J. S. Bach. Or just grumbling.

 

Scott Love, chief operating officer of Soliant Consulting, served at Ziff-Davis Interactive

as an online managing editor, served at Apple Computer as its web publishing technology

evangelist, and led the technical marketing team at Macromedia. He has written dozens

of feature and review articles on database and Internet/web topics for a wide range of

computer publications including Macworld magazine and FileMaker Advisor. He has coauthored

three books: Special Edition Using FileMaker 7, Special Edition Using FileMaker 8, and

FileMaker 8 Functions and Scripts Desk Reference. He is also an authorized Professional

Training Foundation Series instructor and a regular speaker at the FileMaker Developer

Conference. In 2006 he was awarded the FileMaker Excellence Award “for developing outstanding

technical and training resources for FileMaker.” Scott lives in the California Bay

Area where his penchant for gardening can be indulged year round.

Table of Contents

Introduction Welcome to FileMaker 9
Developer Referencep. 1
FileMaker Specifications
FileMaker 9 Product Linep. 9
New Features of FileMaker 9p. 13
Overview of FileMaker 8.5 Featuresp. 21
Overview of FileMaker 8 Featuresp. 25
Specifications and Storage Limitsp. 33
Field Types and Import/Export Formatsp. 37
Calculation Functions
Calculation Primerp. 53
Calculation Signaturesp. 59
Calculation Functionsp. 69
Custom Functions
Custom Function Primerp. 243
Useful Custom Functionsp. 249
Script Steps
Scripting Primerp. 331
Script Step Referencep. 337
FileMaker Connectivity
FileMaker XML Referencep. 439
FileMaker API for PHPp. 453
JDBC/ODBC and External SQL Connectivityp. 489
AppleScript Integrationp. 499
Quick Reference
FileMaker Error Codesp. 511
FileMaker Keyboard Shortcutsp. 521
FileMaker Network Portsp. 539
FileMaker Server Command Line
Referencep. 541
Appendix
A Additional Resourcesp. 553
Indexp. 561
Table of Contents provided by Publisher. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Excerpts

= 0) {slash = '\\';} else {slash = '/';}openLoc = figLoc.substring(0, figLoc.lastIndexOf(slash) + 1);while (pPage.substring(0,3) == '../') {openLoc = openLoc.substring(0, openLoc.lastIndexOf(slash, openLoc.length - 2)+ 1);pPage = pPage.substring(3, pPage.length + 1);}popUpWin =window.open('','popWin','resizable=1,scrollbars=1,location=0,toolbar=0,width=525,height=394');figDoc = popUpWin.document;zhtm= ' ' + pPage + ' ';zhtm += ' ';zhtm += ' ';zhtm += ' ';zhtm += '' + pPage.substring(pPage.lastIndexOf('/') + 1, pPage.length) + '';zhtm += ' ';figDoc.write(zhtm);figDoc.close();}// modified 3.1.99 RWE v4.1 --> Introduction Introduction Welcome to FileMaker 9 Developer Reference Just the FactsThis is the book we've always wanted on our desks. Just as a writer always needs a dictionary nearby, we've found over years of developing FileMaker solutions that it'd be great to have a quick set of reminders within reach. It's impossible to recall each function's syntax or every script step's attributes. Although we use the Let( ) function every day, the exact output of RelationInfo() can be a little less fresh in our minds. This desk reference contains notes on all the script steps and calculation functions in FileMaker; provides lists of other facts such as error codes, port numbers, and XML grammars; and offers a library of useful or instructive custom function examples. We hope this book provides invaluable assistance to like-addle-minded developers everywhere, regardless of your experience with FileMaker. Help Is a Function Key AwayBefore going any further, we'd like to congratulate the tech writers, engineers, and product managers at FileMaker, Inc., for an excellent help system and electronic documentation. If you've never used FileMaker's help resources or website, you're missing a wealth of information. Both are fantastic places to learn, refresh your memory, or uncover areas of FileMaker you had no idea were there.Sometimes, though, it's nice to leave what's on your screen unchanged, keep your work and your reference material separate, and be able to turn to actual paper. (It's hard to take notes in the help system, for example!)Some of this book may overlap a bit with the help system, especially in cases where there's really nothing more to add: for example, as in the Abs() function. Where we hope this book does prove useful is in the additional information and examples we provide, the fact that it's collected all here on paper, and that it's more accessible during those times when you may not be i

Rewards Program