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 - Show more from this author
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.
|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.
Dec 28, 2017
"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, Sydney, Australia
Dec 29, 2017
|Hi Morgan - unfortunately it does require a Table Occurrence as that is how the FileMaker_Tables function works.|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.