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.
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.
For an example on how to use the Delete Rows module, please read the tutorial section on Deleting Table Rows.