Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
FM.QueryFieldsForBaseTableName
Queries the field names of all fields in the given table.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| FM FMSQL | 3.1 | Yes | Yes | Yes | Yes | Yes |
(old name: FM.QueryFields)
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| BaseTableName | The base table name to query. | "test" | |
| FileName | The database file name to look into. If empty or missing, we look in current database. (new in 6.2) |
"Contacts" | Optional |
Result
Returns field names of fields separated by return.
Description
Queries the field names of all fields in the given table.See also FM.QueryFieldsForTableName.
Needs permissions to query your database schema via SQL.
Examples
Query fields in table Kontakte in file Kontakte:
MBS( "FM.QueryFieldsForBaseTableName"; "Kontakte"; "Kontakte" )
See also
Blog Entries
- MBS FileMaker Plugin, version 9.1pr1
- MBS FileMaker Plugin, version 6.2pr3
- MBS Filemaker Plugin, version 3.1pr3
Release notes
- Version 9.1
- Rewrote FM.QueryFieldsForTableName and FM.QueryFieldsForBaseTableName to avoid join operation and gain better performance with lots of tables.
Created 18th August 2014, last changed 7th October 2020
FM.QueryBaseTableNames - FM.QueryFieldsForTableName
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
