ListLocalBaseTables

Lists The Base Tables Local to the Current File

Average rating: 4.8 (25 votes) Log in to vote

Alan Deffenderfer - Show more from this author
ABD Enterprises
https://www.abdenterprises.com

Sample input:

ListLocalBaseTables

Sample output:

SYSTEM
DATA_TABLE
LOGS
ETC

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

       //  SYNTAX:   ListLocalBaseTables
      //   ORIGIN:   http://www.abdenterprises.com
     //    NOTES:    Returns list of all underlying Base Tables for all Table Occurrences that are LOCAL to the current FileMaker Pro v12 file
    //     VERSION:   1.0 - for FileMaker Pro v12
   //      © 2015 Alan Deffenderfer, ABD Enterprises, Inc. Maryland U.S.
// requires FileMaker Pro v12 or higher


ExecuteSQL ( "SELECT DISTINCT BaseTableName FROM FileMaker_Tables WHERE BaseFileName = ?" ; "" ; "" ; 
If ( Get ( ConnectionState ) ; Get ( FileName ) & " (" & Get ( HostName ) & ")" ; Get ( FileName ) )
)

Returns list of all unique underlying Base Tables for all LOCAL Table Occurrences in the current FileMaker Pro v12 file. This requires FileMaker Pro v12 as it uses the new ExecuteSQL function released in FileMaker Pro v12. N.B. it will only return a list of Table 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. File can be hosted too.

Comments

		Bart Bartholomay, South Florida Feb 9, 2015
So, uh, what's this link? http://www.enterprises.com

		Alan Deffenderfer, ABD Enterprises Feb 10, 2015
A mistake (probably autocorrect). It's now fixed. Thanks.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ListLocalBaseTables

Comments

Support this website.

Support this website.