Skip to main content
Question

SQL Command result

  • March 6, 2023
  • 2 replies
  • 83 views
AndyF
Forum|alt.badge.img+6

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.

More of my own ramblings - https://www.lilysdad.com

2 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • 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.

Padmakumar
Raul Jaimes
Forum|alt.badge.img+9
  • Raul Jaimes
  • Navigator | Tier 3
  • 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

Terms & ConditionsCookie settingsAccessibility statement