Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 603
  • Last Modified:

FM External Data Sources Tables

I have a few questions regarding External Data Sources:
1. Can the list of External Data Sources be viewed via a script or calculation?
2. Once a External Data Source (mainly to another filmmaker file) in the Manage External Data Sources window, is it possible to view the list of tables available on the external source via a script or calculation or any other form?
2 Solutions
Lieven EmbrechtsSenior IT ConsultantCommented:
there is no universal answer to your questions as it depends on your external datasource (which can be very different) and it depends on what you want to do, so i'll try to help with some thoughts:
- most of the external datasources functionality in filemaker is limited in what it can and is a manual job (filemaker menus), it's not a universal connector.
- sometimes an external datasource offers a system table with the metadata you want.
- you can copy the metadata (tables & fields) from the external datasource to a local filemaker table (just by  copying and pasting the tables), this can bring you a step closer to what you want.
- have a look at http://www.goya.com.au/baseelements/plugin which goes in the metadata direction, i didn't test it on external metadata though.
Will LovingPresidentCommented:
I don't know of a way to generate a list of external data sources. The "DatabaseNames" function only gives you back a list of files open on the current computer. If the external data source is a FileMaker files and it's open, it might be included in the list (I haven't tried it).

With regard to the list of tables available in an already connected external data source, the "TableNames" function will return a list of all table occurrences in the relationships graph for the specified fileName, separated by carriage returns:

TableNames( fileName )

You could certainly use that in a script or calculation, and the FieldNames function returns a list of all fields on a layout (rather than all fields in a table).

For a complete list of the various "Design" functions, and details on the ones mentioned above see:


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now