Output data tool - missing incoming connections
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
trying to delete records from a SQL table using Output data tool but getting an error - "Missing incoming connections". Is there another tool that can be used to merely delete records from a table using sql query?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Maybe a Text Input tool feeding into a Dynamic Input? I've never tried to run an SQL DELETE command.
Or an Input Data tool?
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If I understand correctly, you are trying to delete all records, correct?
The "Delete Data & Append" is designed to swap out the records for what is incoming into the tool. I believe, if there is an error during the append, the table will be left empty. But no one wants to have errors. :) You could instead have an empty table incoming into this tool. Alternatively, you could run a SQL statement with a DELETE statement.
