Delete and append records based on a parameter
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Reddy4
7 - Meteor
‎08-05-2021
03:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
2 REPLIES 2
19 - Altair
‎08-06-2021
05:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎08-27-2021
01:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I got it working when I ran it as an Analytical app
