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
"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS