FMhelp

by Tim C. Lueth, SG-Lib Toolbox: SolidGeometry 5.6 - Filemaker
Introduced first in SolidGeometry 3.5, Creation date: 2017-02-28, Last change: 2025-08-18

returns a help text for the FileMaker-Matlab interface

Description

Tobias Lüddemann did start the connection of FileMaker and Matlab using 2012b and FileMaker Pro 11. There is a document dated 2014-11-27 at TUM MIMED.
Tim Lueth capsulated the JDBC FileMaker interface using Matlab 2016b and FileMaker 13 starting February 2017. The solution described here works with Filemaker 13 and later.

The Matlab Database Toolbox is required. You need a license for that.
The xDBC Drivers for Filemaker can be downloaded from the Filemaker WWW-Site for your Filemaker Version
The JDBC Driver "fmjdbc.jar" is part of this package.
This driver file has to be added to the javaclasspath (which is done by the function FMinitJDBC)

For connecting to the Filemaker App you have to:
SWITCH ON FILESHARING for ALL Users (Filemaker & Database)
SWITCH ON ODBC-JDBC-Sharing: for ALL Users (Filemaker & Database)

Lueth's functions to support the connection to Filemaker are:
FMhelp - This function
FMinitJDBC - Opens the Driver "fmjdbc.jar"
FMopen - to open a database with user name and password
FMgetFieldTabs - to get informations on the Database
FMsqlQuery - to send requests or data to the Databse
...there are some functions all starting with capital letters "FM"



See Also: FMhelp , FMinitJDBC , FMopen , FMgetFieldTabs , FMsqlQuery

Example Illustration

missing image of FMhelp

Syntax

FMhelp

Examples

How to use the library after copying "fmjdbc.jar" in a search path directory:
FMinitJDBC('fmjdbc.jar')
conn=FMopen('Basename.fmp12','user','passw')
FMgetFieldTabs(conn)
FMsqlQuery(conn,'SELECT * FROM FileMaker_Tables')

References

Filemaker (2013): "SQL-Referenzhandbuch FM 13", https://fmhelp.filemaker.com/docs/13/de/fm13_sql_reference.pdf



Copyright 2017-2025 Tim C. Lueth. All rights reserved. The code is the property of Tim C. Lueth and may not be redistributed or modified without explicit written permission. This software may be used free of charge for academic research and teaching purposes only. Commercial use, redistribution, modification, or reverse engineering is strictly prohibited. Access to source code is restricted and granted only under specific agreements. For licensing inquiries or commercial use, please contact: Tim C. Lueth

Last html export of this page out of FM database by TL: 2025-09-21