In-DB Action Update

[Matt_S]

I'd like to update a SQL statement contained in an In-DB Input tool based on user input through a gallery app. I've added a dummy value into my SQL ('xxx') and selected the Replace a specific string option from within the Action tool. Still, the value in the sql statement is unaffected. Any thoughts on why or if there is a more eloquent solution?

Ignore my connection error, I've simply stripped the details out for this example.

[patrick_digan · Accepted solution]

@Matt_S on the surface it looks like you've set it up correctly. In order to see what's going wrong, I would use the open debug to see what's up.

First make sure the interface designer is visible (View >>> Interface Designer). Then use the second option, the test view, to make a selection from your dropdown. Then you can click on open debug and it will show you a couple things: 1) The box at the top shows you your selection. You can see that I selected the value of a. You can also see that my action tool ran. 2) You can click on the tool and see that it indeed replace xxx with a like we wanted.

[Thableaus]

Hi @Matt_S 

First of all, are you running the app with the magic wand?

Second, when you run as an app you need at least put a browse tool and go to the Interface Designer tab to check the option "On Success Show Results to User"

Cheers,

[Brost]

I'm having similar challenges.  If anyone can help.  I have my action setup to replace a specific string in the sql, I have a browse tool, and I'm getting an error that there's not output files.  Does anyone know what I'm doing wrong?