Check external data source is accessible

[sal88]

Hi all

I have moved a "message object" field from my emails table to a separate FM database called "MessageObjects".

The server schedule runs a receive emails script, which now references that new database as an external data source.

Is there a simple way for the script to check whether that external data source is accessible? I would like the script to halt if it is offline.

I've tried get (layouttablename) from the layout that points to the external table occurrence  but this refers to the table occurrence whether the source is available or not.

The best I've come up with so far is to get it to perform a script that resides within MessageObjects.

Thanks

Edited September 17, 2021 by sal88