Developer’s Guide

Contents vii
Specifying driver properties in the URL subname 9-3
SQL supported by the FileMaker JDBC Driver 9-4
Using DbOpen and DbClose pseudo procedures 9-5
Using the RecordID pseudo column 9-6
Using the ModID pseudo column 9-6
SQL statement examples 9-7
Using a character escape 9-7
FileMaker data type mapping to JDBC SQL and Java
data types
9-7
FileMaker Pro support for Unicode characters 9-7
About the FileMaker JDBC Driver interfaces and extensions 9-8
Example 1: Looking at the FileMaker Pro Explorer application 9-8
Setup requirements 9-8
Install the example and the FileMaker JDBC Driver 9-9
Open and share your databases via the Web 9-9
Run the FileMaker Pro Explorer application 9-9
View the source code of the example 9-10
Example 2: Creating the JBuilder Inventory application 9-11
Install the example and FileMaker JDBC Driver 9-11
Set up JBuilder to use the FileMaker JDBC Driver 9-11
Open and share the Inventory.fp5 database 9-11
Start a new JBuilder project 9-11
Create the data module 9-12
Design the data module 9-12
Test the data module 9-13
Generate the application 9-13
Example 3: Creating the Visual Cafe Inventory application 9-14
Install the example and the FileMaker JDBC Driver 9-15
Set up Visual Cafe to use the FileMaker JDBC Driver 9-15
Open and share the inventory_db database 9-15
Create a new Visual Cafe project 9-15
Using the FileMaker Java classes 9-17
About the FileMaker Java Class Library 9-17
Looking at the Java applet examples 9-18
Chapter 10
Understanding external function plug-ins
About external functions 10-1
About the plug-in example file 10-1
Contents of the FMExample Plugin folder 10-2
Contents of the EFP API folder 10-2
Contents of the Resources folder 10-2
Contents of the Source folder 10-2
Installing, enabling, and configuring the example plug-in 10-3
Description of the FMExample plug-in’s external functions 10-3
Using the example plug-in 10-4
Customizing the plug-in example 10-5
Customizing FMExample.r 10-6
Customizing FMExample.rc 10-6
Customizing FMPrefs.c 10-6
Customizing FMMain.h 10-6
Customizing FMFunct..h 10-6
Customizing FMFunct.c 10-6
Requirements for writing an external function plug-in 10-6
Required code files 10-7
Required resource files 10-7
Feature string syntax 10-8
Requirements for the plug-in’s main entry point 10-9
External function naming conventions 10-10
FileMaker Pro messages sent to the plug-in 10-10
The Initialization message 10-11
The Shutdown message 10-11
The Idle message 10-11
The External Function message 10-12
The Preferences message 10-12
Debugging your plug-in 10-13
Avoiding potential Mac OS resource conflicts 10-13
Providing documentation for your plug-in 10-13
Registering your plug-ins 10-13