Delete Record From Table
Solution No. 51
Deletes all records in the specified table that meet the “Where” condition. Note: if an accounting table is specified, the record will be marked for deletion, but will not actually be deleted until permission is given from your accounting software.
So Where Would We Use It?
The Delete Record From Table action is useful when you wish to delete records from a specific table that meet conditions that you specify. Delete Record From Table will delete the record from the table, leaving other records that do not match the criteria in the same table intact.
Properties
To set the properties for this action, follow these steps:
1. Select Delete Record From Table from the Action dropdown list.
2. Select Table from the dropdown list.
3. Select Where Field from the dropdown list.
4. Select condition from the dropdown list.
The operator choices are:
- Equal to – displays all records that exactly match.
- Greater than – lists all values that are greater than the criterion.
- Less than – lists all values in the field that are less than the criterion.
5. Select Value from the dropdown list.
The choices are:
- Type In – sets the condition to a value that the user types in manually.
- Action Result – sets the condition to a user-defined action result.
- Value From Screen – sets the condition to a value pulled from a specific field within the specified screen.
- Value From Session – sets the condition to a value that results from the current session information.
- Value From Row – sets the condition to a value from a specified row.
6. If you selected Type In for Step 5, enter the predefined value and proceed to Step 7; otherwise, specify a Value from the dropdown list.
7. Enter Internal note (Optional).
8. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
| Created by | John C. on | Nov-19-2012 |
| Last modified by | John C. on | Nov-19-2012 |
