AnsweredAssumed Answered

Text list of table occurrences

Question asked by peteraddison on Dec 12, 2018
Latest reply on Dec 12, 2018 by philmodjunk

How do I make a list of table occurrences? I don't want to print the graph, I want a list.

 

Research tells me this:

 

ExecuteSQL ( “SELECT DISTINCT BaseTableName FROM FileMaker_Tables” ; “” ; “”  )

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

should work, but all I get is a question to select the ODBC Data source which blank, and no way to continue.

 

I seem to be missing some basic concept, or the command/syntax is no longer supported. (since the post is from 2012.)

Outcomes