I am using the "dbquery" command to update tables in MSSQL 2008.
The search is something like:
| dbquery test_db "UPDATE test_table1, test_table2 SET Data1='test1', Data2='test2', Status='Closed' WHERE AccountNumber='1234567890988'"
The inline search updates the database as expected. However the search provides no results which I can use to tell the user if it succeded or not.
The Job inspector shows a message... Update statement executed. 1 rows affected. Is it possible to display this message as a search result?
add select command after update like "select Data1, Data2, Status from test_table1, test_table2 where Status='Closed' and Data2='test2' and Data1='test1' "