Using DBQuery to update DB table data

kenchisho — Mon, 28 Sep 2020 18:26:43 GMT

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?

Re: Using DBQuery to update DB table data

tachifelix — Mon, 28 Sep 2020 18:27:32 GMT

add select command after update like "select Data1, Data2, Status from test_table1, test_table2 where Status='Closed' and Data2='test2' and Data1='test1' "

topic Using DBQuery to update DB table data in Reporting

Using DBQuery to update DB table data

Re: Using DBQuery to update DB table data