FMgetFieldTabs

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 structure of the FielMaker database

Description

FMsqlQuery(conn,'SELECT TableName FROM FileMaker_Tables')
FMsqlQuery(conn,'SELECT * FROM FileMaker_Tables')
FMsqlQuery(conn,'SELECT * FROM FileMaker_Fields')


See Also: FMhelp , FMinitJDBC , FMopen , FMsqlQuery

Example Illustration

missing image of FMgetFieldTabs (conn)

Syntax

FMgetFieldTabs(conn)

Input Parameter

conn: Connector to Database

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)

The function FMgetFieldTabs is designed to interact with a FileMaker database using SQL queries. It is part of the SG-Library and was created by Tim Lueth. The function does not return any values directly but performs a series of SQL queries to retrieve information from the database.

Input Parameters

Function Workflow

  1. The function calls FMsqlQuery with the conn parameter and the SQL query 'SELECT TableName FROM FileMaker_Tables'. This query retrieves the names of all tables in the FileMaker database.
  2. Next, the function calls FMsqlQuery again with the conn parameter and the SQL query 'SELECT * FROM FileMaker_Tables'. This query retrieves all information from the FileMaker_Tables table, which likely includes metadata about each table in the database.
  3. Finally, the function calls FMsqlQuery with the conn parameter and the SQL query 'SELECT * FROM FileMaker_Fields'. This query retrieves all information from the FileMaker_Fields table, which likely includes metadata about each field in the database tables.

The function relies on the FMsqlQuery function to execute the SQL queries. The results of these queries are not stored or returned by FMgetFieldTabs, suggesting that the primary purpose of this function is to perform these queries for their side effects, such as logging or updating a user interface.

Algorithm explaination created using ChatGPT on 2025-08-18 23:28. (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