SQL DBExec - No Error Message Prompt

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
winstein
Pro Scripter
Posts: 84
Joined: Mon Nov 26, 2012 3:44 pm

SQL DBExec - No Error Message Prompt

Post by winstein » Tue Jan 24, 2017 7:42 am

If I run a DBExec, and in the event that the SQL script has an error, how do I disable the error message so that the script can run till the end? The script is intended to be run at an interval, and there might be an event where an SQL data error could occur. Problem is, I don't want the error message to interrupt the Macro since it will cause the process to stop.

Thanks for reading.
PPQ

User avatar
JRL
Automation Wizard
Posts: 3497
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Re: SQL DBExec - No Error Message Prompt

Post by JRL » Tue Jan 24, 2017 1:59 pm

Try adding the line

Let>IGNOREERRORS=1

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts