Jump to content

Iron Python Script - Run Stored Procedure then Refresh Table

Peter Finseth 2

Recommended Posts

I have Tibco Spotfire 7.6.1 Will be upgraded to 10.3.1 by end of May or early June. I have researched on-line and nothing has solved this issue.

In current 7.6 version I have a script that will execute a SQL Server stored procedure. In this stored procedure TableA is updated with new data. I then want to REFRESH TableA within Spotfire but I can not find a way to do this that can all be done in the press of ONE button..."SAVE". Below is what it looks like:

Script Name: Save




To get around this I have two buttons. (1) SAVE button to make the updates to TableA (which is the 1st line of script above) and (2) REFRESH Button (which is the 2nd line of script above). This is very inefficient requiring SAVE then REFRESH buttons to be hit.

How do I get this to just press SAVE so updates are saved and table is refreshed reflecting those changes

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...