FMgetData
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-09-14
returns all field values from a table of an open FileMaker database
Description
Uses the JDBC Driver Solution to access FileMaker from Matlab
The Filemaker SQL Interface is documented in:
See Also: FMopen
Example Illustration
Syntax
ans=FMgetData(conn,fieldname,tabname)
Input Parameter
conn: | | Connector to Database |
fieldname: | | Field Name |
tabname: | | Table Name |
Output Parameter
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
Algorithm (Workflow)
This algorithm is a MATLAB function named FMgetData that retrieves data from a FileMaker database using a JDBC connection. It is part of the SG-Library and was created by Tim Lueth in 2017.
Input Parameters
- conn: This is the database connection object. It is used to establish a connection to the FileMaker database.
- fieldname: This is a string representing the name of the field (column) from which data is to be retrieved.
- tabname: This is a string representing the name of the table from which data is to be retrieved.
Output
- ans: The function returns the data retrieved from the specified field and table in the FileMaker database.
Algorithm Steps
- The function starts by recording the current time using
tic to measure the execution time.
- A SQL query string is constructed using
sprintf. The query is in the format select "fieldname" from "tabname", where fieldname and tabname are the input parameters.
- The
exec function is called with the connection object conn and the SQL query string sqlreq. This executes the SQL query on the database.
- The
fetch function is used to retrieve the data from the executed query, and the result is stored in ans.
- The function ends by recording the elapsed time using
toc.
Algorithm explaination created using ChatGPT on 2025-08-18 23:27. (Please note: No guarantee for the correctness of this explanation)
Last html export of this page out of FM database by TL: 2025-09-21