Delete Record |
  
|
Delete Record |
|
Step 1: Click "Open" from the File Menu. Click on Record page and click "OK".
Step 2: Click on "Add" to add a Row to the Record Page on the Properties Palette window. Click on Edit(0) button corresponding to Cells, to Edit Cell.
Step 3: Drag and Drop RoundButton on the cell. Set Display Text as "Delete". Click on Edit(0) button of the "Delete" RoundButton corresponding to "on tap" function.
Step 4: Actions window open. Select "Local DB Control" Actions Category, click on "Delete" Action.
Enter Action Parameters:-
Parameter |
Description |
Table |
Select Table Name For e.g "emp". |
Where |
User can also specify the where condition to filter the records. The syntax of where condition is like "Fieldname='value'" which is a SQLite3's where syntax. Field Name: Name of the database table field. Value: Data from the table record. For Example: id='7'. |
Step 5: Delete action is applied as shown in the image below. Click on the "+" Action Event Button on the right of the action to view the events.
Step 6: Select "Success" event and click on "Add" button at the bottom. Select "Page Transition" Actions Category, click on "Return To Previous Page" Action.
Step 7: Return to previous page Success action is applied as shown in first image. Click on "+" Action Event Button on the right of this action to add another Success action. The events under "Return to previous page" action is displayed as shown in second image.
Step 8: Select "Success" event and click on "Add" button at the bottom to add action. Select "Main Value" Actions Category, click on "Reload the Updated Data" Action.
Enter Action Parameters:
Parameter |
Description |
Table Page |
Select the Target Page e.g "List" to get an updated list after deleting record. |
Step 9: "Reload Update Data" action is applied on the "Success" event. User can click on the "+" Button on the right of the "Success" event to view the actions applied.
