catch Sql Query error

[#1]

Hello

I want to update a database via the New SQL Query function:

Names Default To Here( 1 );
obj = New SQL Query(
	Connection("DB connection string"),
	Custom SQL "
		UPDATE table
			SET Column_1 = 1
		where Column_2 = '2'
	")
);
Error_Msg = Log capture( obj << Run;);

I get the following error message:

""
Error running SQL Query:
[Server] Invalid object name table

Log Capture only get the empty "" string. So i don't know if the query was successful since it returns an empty string when no error occurs.

simmilar topic but with open database: https://community.jmp.com/t5/Discussions/Catching-database-error-message/m-p/6749#M6743

[#2 · Accepted solution]

You might want to surround your code with these statements to force all error messages to the log:

batch interactive(1);

<your code>

batch interactive(0);

[#3]

Hello @pmroz 
THX, I was about to write a new entry because I run into the "JMP alert" message pop up and the log captured didn't work. I found the following entry: Post about JMP alert with your solution.