Improved the behavior when you perform "Import fields" on the Database Table - Detailed Information screen

Magic

3.3.0

When you execute "Import fields" after you set all the following fields on the Database Table - Detailed Information screen, the behavior has been improved so that the import results are displayed based on the SQL statement.

  • Specify "Output" for "I/O category"

  • Specify "SQL statement" for "Specification method"

 

The commands that correspond to the import of the table name and field name are as follows.

 

Table 2.2 List of commands that correspond to the conversion from SQL statements to SELECT statements

Command 1

Command 2

INSERT

INTO table-name [(table-name.field-name, ...)]

UPDATE

table-name [alias]

SET [table-name.]field-name condition, ...

*Table name is optional

FROM table-name alias

*Usable only in SQL Server

WHERE table-name.field-name condition, ...
= Remarks =

  • Only the first occurrence within a SQL statement is the import target for each command (only one for Command 1).

  • When you specify a field name, add a table name as well.

    Specification of the SET clause is optional as it may not be supported depending on the database.

  • Table names and field names with spaces are not supported.

  • If an import fails due to a SQL statement, the Select Database Table screen is displayed.

  • Checks are not made for the validity of SQL statements.