Search found 2 matches
- Tue Jun 21, 2016 8:46 am
- Forum: Community Forum
- Topic: Delete From File Using Variable
- Replies: 3
- Views: 8120
Re: Delete From File Using Variable
Hi Rick, I don't have a where clause so I'm worried that I'll delete new records that have been added. Let me explain in more detail because I may be using the wrong technique in GoAnywhere. I'll be writing records to table 1 throughout the day. Periodically, likely every 30 seconds, we want to sele...
- Mon Jun 20, 2016 4:19 pm
- Forum: Community Forum
- Topic: Delete From File Using Variable
- Replies: 3
- Views: 8120
Delete From File Using Variable
I see how to select records from table 1 into the "outputVariable" and then insert those records into table 2 using the "inputRowSetVariable". Is it also possible to delete the records from table 1 that were just inserted into table 2 using the same variable?