Plum Fuse

You are here: Plum Fuse Docs » module » Delete Rows

Delete Rows

The Delete Rows module allows you to delete rows from a database from within your application. This module is particularly helpful when you want to delete multiple rows from your database and don't want to do it manually.

NOTE: This module should only be used for prototype applications as there is no 100% guarantee that the data tables will store your data.

To ensure that your data is stored correctly, we recommend the use of the SOAP and REST webservice modules.

Options and Controls

Front Panel Controls

  1. Click this button to display the module menu
  2. Select a Simple Database table from this drop-down menu
  3. Select from this drop-down menu how to aggregate filters in your query
  4. Select a column from your table to filter on
  5. Select a comparison operator from the drop-down menu
  6. Click this toggler to change to a variable containing the operand to compare against the column's value
  7. Enter an operand in this textbox to compare against the column's value
  8. Click this plus button to add another filter
  9. Click this remove button to remove a filter
  10. Enter a limit on the number of rows you want to delete (between 1-99)
  11. Click this toggler to change to a variable containing the index of the first row you want deleted
  12. Enter the index of the first row you want deleted in this textbox

  1. Click this toggler to change to a static textbox, where you would enter the operand to compare against the column's value
  2. Enter the variable containing the operand to compare against the column's value
  3. Click this toggler to change to a static textbox, where you would enter the index of the first row you want deleted
  4. Enter the variable containing the index of the first row you want deleted

Menu Options

Minimized - Selecting this checkbox will hide some of the text of your module to take up less space on your page.

Error handling - Selecting this checkbox will enable additional nodes to handle error cases. The “Invalid query” node will be used when the update operation fails, e.g., the database table was deleted or a permissions error. The “No matching rows” node will be used when no rows match the conditions specified in your query, and so no rows were updated.

Limit rows deleted - Selecting this checkbox will enable/disable limiting the number of rows that are deleted from your database.

Return # rows deleted - Selecting this checkbox will enable a variable that will allow you to return the number of rows that were deleted from your database.

Notes

Examples

For an example on how to use the Delete Rows module, please read the tutorial section on Deleting Table Rows.

module/delete.0.txt · Last modified: 2011/06/24 11:20 by victor