Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5    Statistic  

FM.QueryFieldsForTableName

Queries the field names of all fields in the given table.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
FM 3.1 Yes Yes Yes Yes Yes
MBS( "FM.QueryFieldsForTableName"; TableName { ; FileName } )   More

Parameters

Parameter Description Example value
TableName The table name to query. "test"
FileName Optional
The database file name to look into.
If empty or missing, we look in current database.
(new in 6.2)
"Contacts"

Result

Returns field names of fields separated by return.

Description

Queries the field names of all fields in the given table.
See also FM.QueryFieldsForBaseTableName.

Examples

Query field names for Contacts table:

MBS( "FM.QueryFieldsForTableName"; "Contacts" )

Query fields for contacts in contacts database:

MBS( "FM.QueryFieldsForTableName"; "Kontakte"; "Kontakte" )

Build quoted list of fields:

"\"" & substitute(MBS( "FM.QueryFieldsForTableName"; "Aufgaben" ); ¶; "\", \"") & "\""

See also

Created 18th August 2014, last changed 7th December 2017


FM.QueryFieldsForBaseTableName   -   FM.QueryTableNames

Feedback: Report problem or ask question.




Links
MBS Xojo Chart Plugins