AnsweredAssumed Answered

Lock a layout or record if ODBC source is unavailable

Question asked by MatthewHarrington on Apr 15, 2013

Title

Lock a layout or record if ODBC source is unavailable

Post

     Hello,

      

     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?

     Thanks in advance, Matt.

Outcomes