Forum Discussion
Solved
use parameters in sql query to import data
hi, i`m trying to use parameters to import data, what i need is to use parameters to change de WHERE in de query. I am creating a theme and i want that when i open it they ask me this paramete...
Anonymous And here you go - Feb update with Incremental Refresh for PRO users 🙂
Well, you can set the parameter and use it in your query. For example I use a paramenter to switch all my datasources from test/production db:
Origin = MySQL.Database(server_port, "datawarehouse", [ReturnSingleDatabase=true]),
and server_port is a parameter that I change once.
However I'm not aware of any method to force the db to refresh when you change a parameter. You can change the parameter and then force - manually - a refresh data.