We have a process that use at one point an ODBC request to get a data on a database. This field may not be present on the database and it create an error.
Error: ERROR [HY000] [FileMaker][FileMaker] FQL0009/(1:7): The column named “ETLRajoutInformationMvtType_lmn” does not exist in table “zDEP”.
Source: action “Import from database”, module “Main”, table “Parameters_zDEP”
How can we catch this error and allow the processus to continue? Because today, as soon as we have an ODBC error, it stops everything.
In our idea, if we have the error we would put a default value, if we don’t have the error we get the value from the sql obdc request.
Thanks for support,