Lock a layout or record if ODBC source is unavailable
I am newbie to FM but am using it to push some data to a MYSQL database on a website. ODBC is working great and I can update the MYSQL in realtime with no issues. I want to keep the databases in sync and I want to disallow data entry or edit into the FM table if ODBC is unavailable.
What I need is a script that will test for the ODBC connection and then disallow data entry if the data source is unavailable. Can anyone lead me in the right direction of testing for the ODBC connection?