Developer’s Guide
Table Of Contents
- Contents
- Chapter 1 Introducing FileMaker Developer 5
- Chapter 2 Customizing your database solution
- About the custom solution examples
- Using the FileMaker Developer Tool
- Binding your databases into a runtime database solution
- Displaying databases in Kiosk mode
- Renaming your databases
- Removing design access to your databases
- Customizing the About, Help, and Scriptsmenus
- Adding the FileMakerPro extension to database filenames
- Saving your settings in the Developer Tool
- Chapter 3 Preparing files for a custom solution
- About the Relational Example
- General steps for preparing your solutionfiles
- Issues to consider before creating a runtime database solution
- Opening files in Kiosk mode
- Design tips for navigating in Kiosk mode
- Creating startup scripts
- Using button image samples
- Documenting your database solution
- Design tips for cross-platform solutions
- Creating a consistent appearance
- Simulating outline and shadow text styles
- Using common character sets
- Designing text layouts for cross-platform solutions
- Using a common color palette
- Using graphics in cross-platform solutions
- Using QuickTime movies in cross-platform solutions
- Showing the status bar in Windows
- Using separate scripts for printing
- Using the Status (CurrentPlatform) function
- Creating platform-specific scripts
- Protecting your runtime database solutionfiles
- Testing before and after creating yoursolution
- Converting and upgrading solution files
- Chapter 4 Distributing FileMakerPro runtime database solutions
- Chapter 5 Creating custom layout themes
- Chapter 6 Publishing your database on the Web
- Moving forward using open web standards
- Using the FileMakerPro Web Companion
- Displaying a custom home page
- Using a custom home page with Instant Web Publishing
- Monitoring your site
- Exporting data to a static HTML page
- Testing your site without a networkconnection
- Opening password-protected databasesremotely
- Using the Web Security Database
- Chapter 7 Using FileMakerPro XML to deliver your data
- About the XML examples
- General process for custom web publishing using XML
- Generating an XML document
- Using the FMPDSORESULT grammar
- Using the FileMakerPro Extended XMLgrammars
- About UTF-8 encoded data
- Generating FileMakerPro CGI requests for an XML document
- Using style sheets with your XMLdocument
- Comparing CSS, XSLT, and JavaScript
- Looking at the XML Inventory example
- Chapter 8 Using Java and JDBC to deliver your data
- About the JDBC examples
- About JDBC
- Using the FileMaker JDBC Driver
- SQL supported by the FileMaker JDBCDriver
- FileMakerPro support for Unicodecharacters
- About the FileMaker JDBC Driver interfaces and extensions
- Example 1: Looking at the FileMakerPro Explorer application
- Example 2: Creating the JBuilder Inventoryapplication
- Example 3: Creating the Visual Cafe Inventory application
- Using the FileMaker Java classes
- Chapter 9 Custom web publishing using CDML
- About the CDML examples
- General steps for custom web publishing using CDML
- About CDML format files
- Generating FileMakerPro CGI requests using CDML
- Using the CDML Tool and templates
- New and modified CDML tags
- About the CDML Reference database
- Creating error messages
- Using an encoding parameter with a CDML replacement tag
- Planning your web site
- Chapter 10 Writing external function plug-ins
- About the plug-in examples and templates
- Installing, enabling, and configuring FileMakerPro plug-ins
- Using external functions in a calculation
- Requirements for writing an external function plug-in
- FileMakerPro messages sent to theplugin
- Debugging your plug-in
- Avoiding potential MacOS resourceconflicts
- Providing documentation for your plug-in
- Naming and registering your plug-ins
- Appendix A Feature comparison of the runtime application and FileMakerPro
- Appendix B Valid names used in CGI requests for FileMaker XML data
- Generating a –find, –findall, or –findany request
- Generating a –view request
- Generating a –new request
- Generating an –edit request
- Generating a –delete request
- Generating a –dbnames request
- Generating a –layoutnames request
- Generating a –scriptnames request
- Generating a –dbopen request
- Generating a –dbclose request
- Specifying parameters for the request
- db (Database)
- lay (Layout)
- format (Format)
- recid (Record ID)
- modid (Modification ID)
- lop (Logical operator)
- op (Comparison operator)
- max (Maximum records)
- skip (Skip records)
- sortfield (Sort field)
- sortorder (Sort order)
- script (Script)
- script.prefind (Script before Find)
- script.presort (Script before Sort)
- styletype (Style type)
- stylehref (Style href)
- password (Database password)
- field name (Name of specific field)
- Appendix C FileMaker Pro values for error codes
- Index
I-4
Developer’s Guide
options, described 2-2
preparing files for 3-1
requirements (Mac OS) 1-3
requirements (Windows) 1-3
saving option settings 2-15
specifying files 2-3
using 2-2
FileMaker Java Class Library
described 6-1
using 8-18
FileMaker JDBC Driver
data type mapping 8-7
described 8-1
driver class and main entry
point 8-2
escaping lower ASCII
characters 8-7
examples 8-8, 8-11, 8-15
FileMaker extensions 8-8
implementing JDBC 1.2 API
8-2
including with FileMaker Pro
Java applications and applets
8-2
JDBC interfaces 8-8
opening and closing databases
8-5
registering with the JDBC
driver manager 8-2, 8-3
specifying the JDBC URL 8-2
SQL support 8-4
using 8-2
working with JDK 1.1 and
Java 2 8-2
FileMaker ODBC driver,
installing 1-5
FileMaker Pro 4.0 Developer
Edition, upgrading from 3-16
FileMaker Pro 4.0 Java classes
8-1, 8-17
FileMaker Pro 5
converting databases to 3-16
installing 1-5
FileMaker Pro 5 Unlimited 1-2,
6-3, 8-3, A-1
FileMaker Pro CGI requests
adding records to portals 7-9,
9-4
CDML request and parameter
names 9-4
described 6-2
editing multiple records in
portals 7-9, 9-4
example CGI requests for
XML B-1
for accessing databases 6-2
for CDML 9-3
for instant web pages 6-6
for XML 7-2, 7-8
using JavaScript 7-16
XML request and parameter
names 7-8
FileMaker Pro Explorer
application
described 8-8
starting 8-9
FileMaker Pro Help
See also Help
described 3-7
FileMaker Pro Instant Web Portal
6-4, 6-6
FileMaker Pro plug-ins. See
external function plug-ins
FileMaker Pro themes. See layout
themes
FileMaker Pro Web Companion
plug-in. See Web Companion
FileMaker Pro Web Security
Database. See Web Security
Database
FileMaker Server 5 1-2, 1-6, 4-6
FileMaker Tools databases.
See Interface Elements
databases
FileMaker, Inc.
customer support 1-9
registering external function
plug-ins 10-1, 10-13
FileMakerExplorer.java file 8-10
filename extensions
adding or removing .fp5 2-15
desktop conflicts (Mac OS)
2-8
for runtime databases 2-8
registered by runtime
applications 4-6
registry conflicts (Windows)
2-8
filenames for instant web pages
6-8
files
automatically opening in
Kiosk mode 2-9, 3-3
closing in Kiosk mode 2-10
converting to FileMaker Pro 5
3-16
cross-platform 3-10
preparing 3-2, 3-10
recovering damaged 4-7
required for external function
plug-ins 10-7
Find mode in runtime
applications A-1
-find requests 7-13, 7-14, B-1
FMBanner applet 8-18
FMBanner.fp5 database 8-19
FMExtern.c and FMExtern.h files
10-7
FMFlags.h header file 10-7
FMMemoPad applet 8-18
FMMemoPad.fp5 database 8-19
FMP.js JavaScript library 7-16,
7-17, 7-21
FMPDSORESULT grammars 7-3
FMP-If tag 9-10
FMP-Include tag 9-18
Fmpjdbc12.jar file 8-2
FMP-Log tag 6-9
FMProProxy Java class 8-18
FMProRequest Java class 8-18
FMProResponse Java class 8-18
Fmprt50.hlp file (Windows) 4-1
FMPXMLLAYOUT grammars
7-7
FMPXMLRESULT grammars
7-6
FMTemplate.c code file 10-7
FMTHEME element 5-2
FONT attribute 5-7
Fonts folder, including with
runtime databases (Mac OS) 4-3
fonts for cross-platform databases
3-10
footer layout parts 5-5
Format encoding parameter 9-14
format files
described 9-2
templates, using 9-6
-format request parameter B-6
fp5 filename extension, adding
2-15
Full Example plug-in
functions and parameters,
described 10-6
TechInfo article 10-7
function name prefix for external
function plug-ins 10-10
functions
See also external functions
Status (CurrentError) C-1
Status (CurrentPlatform) 3-13
Web- external functions 6-11
Xpl- external functions 10-5,
10-6