Even if a view filter is set, all views are displayed in the Data Source Explorer view
[Symptom]
In the Data Source Explorer view, in the "view" item properties, even if [Disable filter] is cleared to enable filters, all views are displayed in the Data Source Explorer view.
[Action]
In the Data Source Explorer view, in the "view" item properties, view filtering cannot be performed. If you want to filter a view, in the schema that view belongs to, under "table" item properties, specify a filter. The "table" item filter settings are applied to both the table and the view.
It might not be possible to delete Symfoware Server tables
[Symptom]
After a Symfoware Server table is edited using the Table Data editor, the "DROP TABLE" SQL statement fails. If table deletion fails, in the SQL Results view, "JYP3913E Table "table name" being used exclusively by another user." will be displayed.
[Action]
In the Data Source Explorer view, disconnecting the database, then connect to it again. After this, execute the "DROP TABLE" SQL statement.
Symfoware Server indexes are displayed using a different name (DSO name)
[Symptom]
In the Data Source Explorer view, the list of indexes defined in the database can be displayed. If connected to the Symfoware Server, not the index name but rather the DSO name will be displayed in the index name.
When the table [Delete] context menu is selected, the "DROP TABLE" SQL statement is generated. If an index is defined in a table, then the "DROP INDEX" SQL statement is also generated. If connected to the Symfoware Server, then the DSO name (instead of the index name) will be specified in the SQL statement that deletes indexes. As a result, when the SQL statement that deletes indexes is executed, this feature might fail.
[Action]
Either specify the index name in the SQL statement that deletes indexes or execute the "DROP DSO" and "DROP DIS" SQL statements. The DSO name of the index is the same as the DSI name.
