Manipulating Data in TBS Browser¶
The table records can not only be viewed in Table data Viewer page but it gives various useful features which can be performed over these records. All the Non-XML field records are shown in simple tabular fashion and XML fields can be accessed (if exist any) by expanding a record.
View XML Data¶
Each of the records shown in the table browser can be expanded to see the XML fields (if exist any). When a XML field is selected, clicking on Show XML results in displaying the XML data by opening up a XML file.
Few warning messages as shown below can be popped-up if a user tries to modify the XML data in viewing mode. The data can only be modified in Insert and Edit mode.
View XML Data - Design View¶
This shows the XML data in tree view making navigation and editing simple.
View XML Data - Source View¶
This shows the XML data in source view.
Edit Non-XML Records¶
The Non-XML data can be edited by clicking on the Edit Mode button. All the Non-XML fields in the selected record will be displayed in editable fields on the bottom of the page. A user can modify the field values of any record in the batch under the Edit Mode.
Click on the Commit to reflect the changes in database table. Clicking on Cancel will rollback the batch data to its initial state before the Edit Mode started.
Edit XML Field¶
Read the section Edit XML data for details on editing XML field data.
Insert Records¶
The new records can be inserted by getting into insert mode by clicking on the Insert Mode button. All the non-xml fields can be set in the bottom of the page whereas XML field data can be inserted by clicking on the Insert XML button after selecting the XML field of the record. Add Records is used to add a new record in the Insert Mode. These records will be finally inserted to database table by clicking on the Commit button. Clicking on Cancel will have no effect on database table.
Copy Record¶
Select a record and click on the Copy Record button to copy the selected record. This gets into the Insert Mode with the selected record set in the editable fields. The XML field data can be edited using :guilabel`Insert XML` button and also a new record can also be added by clicking on Add Record. Commit and Cancel button serve the same purpose as Insert Mode.
9. Delete Records¶
Click on the Delete Record button after selecting one or multiple records in a batch of records. This will delete the records from database table.
