SQL Query Manual Update

General Discussion
1

How can we manually update a SQL Query that is calling a stored procedure? I found the post where you can add a client tag and use that in the query to retrigger.

SELECT Col FROM Table WHERE {[~]MakeQueryUpdate} IN (0,1)

I suppose I could add a dummy parameter to the stored proc and do the same thing, but hopefully there’s a better approach.

2

We just spoke on the phone, but I wanted to answer this in case someone else runs into the same problem.

You can use the system.db.refresh() scripting function to force any query to be re-run. You can put this in a button on-screen, or a timer, or anywhere else you have an event script.