Muutke küpsiste eelistusi

FileMaker 9 Developer Reference: Functions, Scripts, Commands, and Grammars, with Extensive Custom Function Examples [Pehme köide]

  • Formaat: Paperback / softback, 600 pages, kõrgus x laius x paksus: 179x231x35 mm, kaal: 916 g
  • Ilmumisaeg: 09-Aug-2007
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789737086
  • ISBN-13: 9780789737083
Teised raamatud teemal:
  • Pehme köide
  • Hind: 43,74 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Paperback / softback, 600 pages, kõrgus x laius x paksus: 179x231x35 mm, kaal: 916 g
  • Ilmumisaeg: 09-Aug-2007
  • Kirjastus: Que Corporation,U.S.
  • ISBN-10: 0789737086
  • ISBN-13: 9780789737083
Teised raamatud teemal:
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.

Muu info

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.
Introduction Welcome to FileMaker 9 Developer Reference 1(1)
Just the Facts
1(1)
How This Book Is Organized
2(7)
I. FileMaker Specifications
FileMaker 9 Product Line
9(4)
Overview of FileMaker Products
9(4)
FileMaker Pro 9
9(1)
FileMaker Pro 9 Advanced
9(1)
FileMaker Server 9
10(1)
FileMaker Server 9 Advanced
10(3)
New Features of FileMaker 9
13(8)
FileMaker Pro/Advanced 9
13(5)
Conditional Formatting
13(1)
Auto Resize Layout Objects
14(1)
External SQL Data Sources
15(1)
ScriptMaker Enhancements
16(1)
And More
17(1)
FileMaker Server 9
18(3)
Running ScriptMaker Scripts
18(3)
Overview of FileMaker 8.5 Features
21(4)
FileMaker Pro 8.5
21(4)
Web Viewer
21(1)
Object Names
22(1)
List Function
23(1)
FileMaker Learning Center
23(1)
Support for Intel-Based Macs
23(2)
Overview of FileMaker 8 Features
25(8)
FileMaker Pro 8
25(6)
Script Variables
25(1)
Tab Control
25(1)
Buttons in the Tab Order
26(1)
New Field Control Options
26(1)
Go to Related Record by Found Set
27(1)
Save as PDF
27(1)
Save as Excel
28(1)
Fast Mail
28(1)
Date and Time Range Shorthand Searching
28(1)
Fast Match
29(1)
Import as New Table
29(1)
Relationships Graph Enhancements
30(1)
New Calculation Functions
30(1)
FileMaker Pro 8 Advanced
31(2)
Custom Menus
31(1)
ToolTips
31(1)
Data Viewer
32(1)
Copying and Pasting Schema Objects
32(1)
Specifications and Storage Limits
33(4)
Knowing Your Limits
33(2)
External SQL Sources (ESS) Specifications
35(2)
Field Types and Import/Export Formats
37(16)
Knowing Your Data
37(1)
FileMaker Field Types
38(5)
Text
38(1)
Number
39(1)
Date
39(1)
Time
40(1)
Timestamp
41(1)
Container
42(1)
Calculation
42(1)
Summary
43(1)
Additional ESS References
43(1)
Importing Data
43(4)
File-Based Data Sources
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)
Exporting Data
47(6)
Exporting to HTML
48(1)
Exporting to FileMaker Pro
48(1)
Exporting to Excel
48(1)
Automatically Opening or Emailing Exported Files
49(4)
II. Calculation Functions
Calculations Primer
53(6)
The Calculation Function Interface
53(6)
Calculations: Things to Remember
54(5)
Calculation Signatures
59(10)
Aggregate Functions
59(1)
Date Functions
59(1)
Design Functions
60(1)
External Functions
61(1)
Financial Functions
61(1)
Get Functions
61(3)
Logical Functions
64(1)
Number Functions
64(1)
Repeating Functions
65(1)
Summary Function
65(1)
Text Functions
65(2)
Text Formatting Functions
67(1)
Time Functions
67(1)
Timestamp Function
68(1)
Trigonometric Functions
68(1)
Calculation Functions
69(174)
III. Custom Functions
Custom Function Primer
243(6)
The Custom Function Interface
244(5)
Custom Functions: Things to Remember
244(5)
Useful Custom Functions
249(82)
Sample Custom Function Library
249(1)
Number Calculations
249(6)
Date Calculations
255(4)
Text and Data Conversions
259(17)
Email Tools
276(2)
List Handlers
278(8)
Developer Tools
286(4)
System Constants
290(2)
Toolkit for Complex Data Structures
292(19)
Data API Within FileMaker
292(1)
Data Tree
293(1)
Using XML as a Data Structure
293(1)
Path-Based Selections
294(3)
The Functions
297(14)
Storing (and Unstoring) Text Data as CSS
311(20)
How the Functions Work
312(1)
The Functions
313(18)
IV. Script Steps
Scripting Primer
331(6)
About FileMaker Scripting
331(6)
The ScriptMaker Interface
331(1)
Where Scripts Live
331(2)
Organizing Scripts
333(1)
Filtering Scripts
333(1)
Script Privileges
333(1)
Debugging Scripts
334(1)
Scripting for the Web
335(2)
Script Step Reference
337(102)
About the Script Step Reference
337(102)
V. FileMaker Connectivity
FileMaker XML Reference
439(14)
About FileMaker and XML
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)
FileMaker XML Grammars
441(5)
Query Parameters for XML/XSLT URL Requests
446(5)
Query Commands
447(1)
Query Parameters
448(3)
FileMaker XML and XSLT Namespaces
451(2)
FileMaker API for PHP
453(36)
About the FileMaker API for PHP
453(1)
Class Overview
453(1)
Classes and Methods
454(35)
FileMaker
454(7)
FileMaker_Command
461(2)
FileMaker_Command_Add
463(1)
FileMaker_Command_CompoundFind
464(1)
FileMaker_Command_Delete
465(1)
FileMaker_Command_Duplicate
465(1)
FileMaker_Command_Edit
465(2)
FileMaker_Command_Find
467(2)
FileMaker_Command_FindAll
469(1)
FileMaker_Command_FindAny
469(1)
FileMaker_Command_FindRequest
469(1)
FileMaker_Command_PerformScript
470(1)
FileMaker_Error
470(1)
FileMaker_Error_Validation
471(2)
FileMaker_Field
473(5)
FileMaker_Layout
478(3)
FileMaker_Record
481(4)
FileMaker_RelatedSet
485(1)
FileMaker_Result
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)
AppleScript Integration
499(12)
Understanding AppleScript
499(2)
The AppleScript Interface
501(2)
About the AppleScript Object Model
503(2)
Understanding the Application Dictionary
505(2)
AppleScript Examples
507(1)
Other Resources
508(3)
VI. Quick Reference
FileMaker Error Codes
511(10)
Error Codes in FileMaker
511(10)
FileMaker Keyboard Shortcuts
521(18)
Working Quickly, Saving Time
521(1)
Essential Shortcuts by Group
522(6)
Keyboard Essentials
522(1)
Navigation
523(1)
Data Entry and Formatting
524(1)
Managing Fields
524(1)
Working with the Relationships Graph
525(1)
Working with Layouts
526(1)
Scripting
527(1)
Navigating the FileMaker Interface
528(1)
Menu Reference
528(11)
File Menu
528(1)
FileMaker Pro/Advanced Menu (Mac OS Only)
529(1)
Edit Menu
530(1)
View Menu
530(1)
Insert Menu
531(2)
Format Menu
533(1)
Layouts Menu (Layout Mode Only)
534(1)
Records Menu
535(1)
Requests Menu (Find Mode Only)
535(1)
Arrange Menu (Layout Mode Only)
536(1)
Scripts Menu
536(1)
Tools Menu (FileMaker Pro Advanced Only)
537(1)
Window Menu
537(1)
Help Menu
538(1)
FileMaker Network Ports
539(2)
About Network Ports
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)
VII. Appendix
A. Additional Resources
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)
FileMaker News Sources
556(1)
Plug-ins
556(2)
Developer Tools
558(1)
Web Programming
558(1)
XML/XSL
559(1)
PHP
559(1)
ODBC/JDBC
560(1)
Index 561
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.