3 Replies Latest reply: Jan 14, 2014 12:00 PM by Egor Kobylkin RSS

    Suppress error message at script runtime

    Egor Kobylkin

      I have a list of fields that I want to get dropped from the tables that get loaded in a loop.

       

      FOR each tablename in $(varTableNames)

      LOAD * ; select * from $(tablename);

      DROP Fields $(varFieldNames);

      NEXT;

       

      The varFieldNames is a comma separated list of some random fields in the form of 'Table1.field1','Table2.field5' etc.. Now e.g. if the tablename is not the Table1 I get a pop-up with the error message "wrong field name in the drop fields statement" or something for the Table1.field1. It breaks the script execution.

       

      Is there a way to suppress that behavior? I just want to ignore the those errors and let the script run through.