1 Reply Latest reply on Oct 13, 2012 5:19 PM by sporobolus

    Dynamic Script to Compile List of External Data Sources

    user12837

      How does one write a script which will store, either in a table, field, or variable, a list of all external data sources in a FM 11 file?

       

      Thanks,

       

      Tom

        • 1. Re: Dynamic Script to Compile List of External Data Sources
          sporobolus

          on 2012-10-13 8:18 user12837 wrote

          How does one write a script which will store, either in a table, field, or variable, a list of all external data sources in a FM 11 file?

           

          if all you want is the external filenames, this works in FileMaker 12:

           

          ExecuteSQL ( "SELECT distinct BaseFileName FROM FileMaker_Tables where

          BaseFileName != ?" ; "" ; "" ; Get ( FileName ) )

           

          so i'd assume this would work using ScriptMaster in FileMaker 11 (untested):

           

          ExecuteSQL ( "SELECT distinct BaseFileName FROM FileMaker_Tables where 
          BaseFileName != \"" & Get ( FileName ) & "\"" )