Question

SQL Command result

  • 6 March 2023
  • 2 replies
  • 49 views

Badge +4

Is it possible with the Database: Run stored procedure command to capture the output from theSQL command.

 

I have a SP that performs a SQL Update to a table, and wondering if it is possible to capture the output of the SP to confirm the record was updated.


2 replies

Userlevel 7
Badge +13

Hi @AndyF ,

 

There is an option Export Data to CSV in the Database:Read action where you can see the result from an SQL read query. But unfortunately, there is nothing like that for Insert/Update/Delete action.

Userlevel 5
Badge +9

@AndyF 

Maybe you can create a table with a single record to save the output from your SP adding an extra insert on it. 

 

HTH

Regards

Reply