| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
FM.QueryFieldsForBaseTableName
Queries the field names of all fields in the given table.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| FM FMSQL | 3.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "FM.QueryFieldsForBaseTableName"; BaseTableName { ; FileName } ) More
(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
Release notes
- Version 9.1
- Rewrote FM.QueryFieldsForTableName and FM.QueryFieldsForBaseTableName to avoid join operation and gain better performance with lots of tables.
Blog Entries
- MBS FileMaker Plugin, version 9.1pr1
- MBS FileMaker Plugin, version 6.2pr3
- MBS Filemaker Plugin, version 3.1pr3
- MBS Filemaker Plugin, version 3.1pr1
This function checks for a license.
Created 18th August 2014, last changed 7th October 2020
