1 Reply Latest reply on Aug 19, 2015 9:11 AM by philmodjunk

    Catching errors during import



      Catching errors during import


      I want to catch potential errors while importing records. note: Set error capture is set to on at the beginning of the script.

      My first question is: Which error capturing function should I call after executing the "import" script step (configured for ODBC), Get (LastError) or Get (LastODBCError)?

        • 1. Re: Catching errors during import

          I'd use both if possible to check for both types of errors with the Get ( LastError ) check immediately after the Import step. But there's a good chance that to fully check for errors you may need to use a script that loops through the found set of records produced by your found set in order to locate individual records with a problem and, if necessary either flag them for closer inspection or to correct the error if it is possible to make the correction via script.