ListLocalFQFieldNames ( )

Function stats

Average user rating
474
376
9999
Support
FileMaker 10.0 +
Date posted
11 February 2015
Version
1
Recursive function
No

Author Info
 Kris Musshorn

1 functions

Average Rating None

author_avatar



 

Function overview

Prototype

ListLocalFQFieldNames  (  )


Parameters

No parameters for this function.


Description

Tags:  SQL   Fields   Field  

Returns list of all Field Names for all LOCAL Tables in the current FileMaker Pro v12 file. This requires FileMaker Pro v12 as it uses the ExecuteSQL function. It will only return a list of Field Names for Table Occurrences that are on the relationship graph - if you have a Local Table with no associated Table Occurrences on the graph it will not appear in the result.

Examples

Sample input

None


Sample output

TableName1::FieldName1
TableName1::FieldName2

 

Function code

// SYNTAX: ListLocalFQFieldNames
// ORIGIN: http://www.krismusshorn.com
// NOTES: Returns list of all Fully Qualified Fields all Table Occurrences that are LOCAL to the current FileMaker Pro v12 file
// VERSION: 1.0 - for FileMaker Pro v12
// © 2015 Kris Musshorn
// requires FileMaker Pro v12 or higher
// edited 2-10-2015 to poll connection state in order to function on non hosted files


Let (
[
_cs = Get ( ConnectionState ) ;

_local_fq_fields = ExecuteSQL ( "SELECT t.BaseTableName, f.FieldName FROM FileMaker_Fields AS f JOIN FileMaker_Tables as t ON t.TableName =
f.TableName WHERE t.BaseFileName=?" ; "::" ; "";
If ( _cs = 0 ; Get ( FileName ) ; Get ( FileName ) & " (" & Get ( HostName ) & ")" )
)
];

_local_fq_fields

)

// ===================================
/*

    This function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/376

    Prototype: ListLocalFQFieldNames( )
    Function Author: Kris Musshorn (http://www.fmfunctions.com/mid/474)
    Last updated: 11 February 2015
    Version: 1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (31)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Interface  (15)
Layout  (15)
Text  (14)
Variables  (12)
Layout Objects  (11)
Filter  (11)
Design  (10)
Array  (7)