Create Script to detect ODBC File
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.