Every table from the Data Source Explorer view can be displayed and edited in the Table Explorer view by pressing the Edit button from the contextual menu or by double-clicking one of its fields. To modify a cell's content, double click it and start typing. When editing is finished, Oxygen XML Editor plugin will try to update the database with the new cell content.
The Table Explorer View
You can sort the content of a table by one of its columns by clicking on its column header.
Note the following:
.For performance issues, you can set the maximum number of cells that will be displayed in the Table Explorer view ( the Limit the number of cells field from the Data Sources Preferences page). If a table having more cells than the value set in Oxygen XML Editor plugin 's options is displayed in the Table Explorer view, a warning dialog will inform you that the table is only partially shown.
You will be notified if the value you have entered in a cell is not valid (and thus it cannot be updated).
If the content of the edited cell does not belong to the data type of the column, an Information dialog will appear, notifying you that the value you have inserted cannot be converted to the SQL type of that field. For example, in the above figure propID contains LONG values. If a character or string was inserted, you would get the error message that a String value cannot be converted to the requested SQL type (NUMBER).
If the constraints of the database are not met (like primary key constraints for example), an Information dialog will appear, notifying you of the reason the database has not been updated. For example, if you'd try to set the primary key propID for the second record in the table to 10 also, you would get the following message:
Duplicate entry for primary key
The usual edit actions (Cut, Copy, Paste, Select All, Undo, Redo) are available in the popup menu of the edited cell.
The contextual menu available on every cell has the following actions:
Insert row - Inserts
an empty row in the table.
Duplicate row - Makes a
copy of the selected row and adds it in the Table Explorer view. You
should note that the new row will not be inserted in the database table until all conflicts
are solved.
Commit row - Commits the
selected row.
Delete row - Deletes the
selected row.
Copy - Copies the content of the
cell.
Paste - Performs paste in the
selected cell.Some of the above actions are also available on the Table Explorer toolbar:
Export to XML - Opens
the Export Criteria dialog (a
thorough description of this dialog can be found in the Import from database
chapter) .
Refresh - Performs a refresh
of the selected node's subtree.
Insert row - Inserts
an empty row in the table.
Duplicate row - Makes a
copy of the selected row and adds it in the Table Explorer view. You
should note that the new row will not be inserted in the database table until all conflicts
are solved.
Commit row - Commits the
selected row.
Delete row - Deletes the
selected row.