AnsweredAssumed Answered

Create Script to detect ODBC File

Question asked by liquidcooled on Feb 24, 2010
Latest reply on Feb 24, 2010 by liquidcooled

Title

Create Script to detect ODBC File

Post

Hello, 

I'm new to filemaker and have a database that "syncs" with an external ODBC database. I have a script "syncs / imports" data from the ODBC source. My script works great except for when my ODBC database is not available I get an error message from filemaker that says " "?" could not be opened. (Not Found) " How can I write a script that will Detect this error create a custom message for the user that is more informative and also exits the script so that it does not continue to try and import the other files. 

 

I think that I need to use Get (LastODBCError) but I'm not sure how to use that with the error message supplied by FM.

Thanks 

Outcomes