Manage Data
Manage Data allows to perform operations on database like select, insert, update and delete. This topic will provide guidelines as on how to utilize the functionalities of this page. This page is accessible only if its availability is configured at Manage Site Users for that particular user.
Manage Data section displays the following details in tabular form
| Options | Description |
|---|---|
Database Name |
Select the name of the database from the drop-down |
Tables |
Select the table of the database which is selected in 'Database Name'. |
Custom Filter |
Enter the custom filter condition |
Max Records |
Enter the maximum number of records liable from the table |
Query Result
The following result are displayed in the grid upon 'Get data' for the configuration.
-
Add: Select the plus icon to add new record.
-
Edit: Select the edit icon to edit record.
- Delete: Select the trash icon to delete record.
- Save: The changes in the grid will be applied to the database only if they are saved using this button.
Note: If table has no primary key in Microsoft Access database then user cannot perform edit and delete operations on that table.