Delete and append records based on a parameter

[Reddy4]

Hi,

I am using a dynamic input tool to pass a month parameter and pull the records for that month from Oracle. I want to Insert these records to a table but before that I would like to delete any records for that month (If they exist).

I have used a simple Pre Create SQL Statement - DELETE FROM Tablename WHERE Month = &&Month. I am using an action button to update the PreSQL Statement's &&Month, but it doesn't work. It looks like the parameter is not reaching the Pre-SQL Statement

Can someone help me achieve it.

P.s: I cannot use In-DB tools

[danilang]

hi @Reddy4 

Can you post your workflow?  If not, post images of the config of the action tool that should be updating the &&month values

Dan

[Reddy4]

I got it working when I ran it as an Analytical app