This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sure, you have your text box that updates a value I assume, the value being 20160000 in this case. In the Dynamic Input tool you initially load your select statement to give the tool a template it expects the inputs to return (Input Data Source Template).
In your case that could be:
select * from a inner join b where a.x=.b.x and b.year=20160000
In the Dynamic Input choose Modify SQL Query, Add, Replace a Specific String. The 'Text to Replace' would be 20160000 and the Replacement Field would be the field where the value returned from the text box is written (which I assume writes into a field).
You don't need to have a standard Input tool feeding the dynamic input. Better to have a Text Input tool containg your Date variable, which you would connect up to your Text Box.
In the Dynamic Input tool, at the top, it says Input Data Source Template. That is the equivalent of the standard Input tool. Load your initial SQL statement there, just as you would with a standard Input tool.
Once that is done you can Modify SQL Query using the Date variable to Replace a Specific String.
Not sure if it's just me but this new forum style is very hard to work out what's going on...
Anyway, you're more or less there. Where it says 'replace specific string' you should only leave the bit of your SQL statement you want to replace there. In your case it would be 20160000. Delete the rest of the SQL statement from that box. Whatever is in the box is the string that will be replaced.
Thank you for your quick turn around. I got one issue When I run using app I got and error when I checked the log Isee the number which I'm passing is comig in and but I missed with column name some thing like this I got
where a.x=b.y and a.a1="A" and b,mn=12 and 20160000