Skip to main content
Question

SQL Command result


AndyF
Forum|alt.badge.img+5

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

Padmakumar
Forum|alt.badge.img+14
  • Navigator | Tier 3
  • 786 replies
  • March 6, 2023

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.


Raul Jaimes
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 494 replies
  • March 14, 2023

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings