Thank you for your post, and I apologize for the late reply.
I don't have access to a MySQL database, so I'm unable to test this. However, I have sent the entire post to our Development and Software Quality Assurance (Testing) departments for review and confirmation. When more information becomes available, I'll let you know.
I have been using FMP as a CMS for website management via the ODBC driver. Occasionally I get the same ODBC connection error and it locks up the application and I have to perform a forced close of the application. I too had thought about using a Error capture statement along with a Comment function but I see that another tried and had no success with this issue.
Here is a possible workaround that I am considering as I do encounter this problem and it is a real hassle, especially when adding new records.
I haven't tried this yet but I will let you know how I made out. If you get to it first, let me know.
Create a matching lookup table on your client PC/Mac machine with the same fields as the table you are working with. Create a link between the tables with a link using a key field (as a sure you already know). Set the relationship so that creating new records in the lookup table creates a new record in your original table. So instead of adding news records into your original table, you're entering them in the lookup table first. Then you can use the committing function to save the record in your original table. In this way, if you do encounter an ODBC error when committing the record, you can escape from the error by simply deleting the record. You can then write a script to copy the record you entered into the lookup table back to your original ODBC table once the connection issue is resolve. Use a similar version of this concept to update records by copying the record you want to update into your lookup table first and making the changes there before committing them to you original table.
t to update into your lookup table first and making the changes there before committing them to you original table.