8.4.4. ViewCreator ・TableMaintenance¶

On the query edit screen of ViewCreator, column type is automatically set when the column is added.

Column type can be changed, but some unexpected error may happen when the data is obtained.

Operations when the changes are made are outside the scope of support.

In the column list on query edit screen, if one or more [Sort] items are set,

ORDER BY phrase will be included in the SQL statement generated by [View Creation].

Depending on the database product in use or its version, it may not be possible to use ORDER BY in CREATE VIEW.

Please edit and run SQL statement as appropriate.

On the record edit screen of TableMaintenance function, blank cells may be inserted to the header line, and the columns may be displayed as shifted.

This symptom occurs only in environment in which Internet Explorer 9 is used.

In case Internet Explorer 8 is used, 2-byte characters in SQL display on query edit screen are corrupted.

<*> This is a display only problem, and does not affect the functional operations.

In case input/output is made to the CLOB-type field for the following functions,

character code of input data and output data will be UTF-8 and fixed.

・Text data download/upload to CLOB-type field on record edit screen of TableMaintenance

・Table export function of TableMaintenance

・Table import function of TableMaintenance

・CSV output function in List Summary of ViewCreator

If text data other than UTF-8 is used as input data, character corruption would occur.

In the display setting of List (Summary) Total, if image icon has been selected instead of data for display setting,

the image may not be displayed on smart phones.

If characters other than the ones listed below are used for table name, view name, or field name are used

according to the specifications of each product, they cannot be correctly handled by TableMaintenance.

Moreover, when the reserved words of SQL are used, they are out of support.

* Oracle or DB2 case

* PostgreSQL or SQLServer case

Summary total setting that was created by ViewCreator of intra-mart WebPlatform or intra-mart AppFramework cannot be migrated to intra-mart Accel Series.