Brian Dunning's FileMaker Custom Functions

ListBaseTables

Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file

  Average rating: 4.7 (23 votes) Log in to vote

Andrew Duncan   Andrew Duncan
Databuzz
https://www.databuzz.com.au

Share on Facebook Share on Twitter

  Sample input:
ListBaseTables
  Sample output:
Companies
People
Invoices

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

Returns list of all unique underlying Base Tables for all 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 all Table Occurrences that are on the relationship graph - if you have a Table with no associated Table Occurrences on the graph it will not appear in the result.

 

Comments

Omega Goh   Omega Goh, Singapore
Jul 23, 2013
This is fantastic!

Prior to this, the design function, TableNames returns a list of Table Occurences which I could elimnate only base on my own Naming Convention. For solutions that were not using my own Naming Convention, I have to split the Table Occurence Name to get the list of Field Names to guess the "duplicate". It would tricky if there are two or more Base Tables with the same list of Fields, though not often.

Thank you for your contribution, Andrew.
 
Morgan   Morgan, Denver
Dec 28, 2017
ExecuteSQL (
"SELECT DISTINCT BaseTableName FROM FileMaker_Tables
WHERE BaseFileName LIKE '" & Get ( FileName ) & "%'"

; "" ; "" )

This pulls up only the distinct base tables of the Table Occurrences in the file. If there is no TO for that table, it doesn't show here.
 
Andrew   Andrew, Sydney, Australia
Dec 29, 2017
Hi Morgan - unfortunately it does require a Table Occurrence as that is how the FileMaker_Tables function works.
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.