Catching ODBC error to allow process to continue

Hello,

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,

Pierre-Alexandre

Hello Pierre-Alexandre and welcome to the Community!

To catch errors, put the action that fails into a separate module, and call this module using the “Call another module or project” action in the “Capture errors and continue mode”.

See also: Capture internal error - #2 by andrew.rybka

hello

Thank you for your answer which was very useful to us.

Alain