Granted Patent B2

US 12,372,937 · App. 17/837,268 · Granted Jul 29, 2025

Inventors: Tomonari Inui (Kusatsu, JP); Kotaro Okamura (Kusatsu, JP)

Assignee: OMRON CORPORATION

G05B19/056G06F16/22

Abstract

Claims (44)

1. A control system for controlling a control target, the control system comprising:

a database configured to hold one or more tables; and

a control apparatus for production process automation, the control apparatus comprising control circuitry configured to access the database,

wherein the control apparatus is configured to perform at least:

acquiring a column name and a data type of each column of a table, the table being selected from among the one or more tables;

determining a data type of each member in correspondence with the acquired data type of each column, the data type being available in a user program,

displaying a screen including the column name and the data type of each column, and the data type of each member brought into correspondence with the data type of each column, and

generating at least part of the user program based on the determined data type of each member and one or more selected items,

wherein the determining comprises determining the data type of each member based on a list showing a correspondence between a data type of a column and a data type of a member,

wherein at least one of the one or more selected items is for addition of a record into the table in the database, and

wherein the generating comprises generating the at least part of the user program including an instruction corresponding to the at least one of the one or more selected items with a value set to each member being an input element in the user program.

2. The control system according to claim 1 , wherein the determining comprises determining the data type of each member from among data types available in the user program.

3. The control system according to claim 1 , wherein the determining comprises determining the data type of each member in accordance with a user operation.

4. The control system according to claim 1 , wherein

the user program includes a first function block for executing an instruction to control access to the database, and

in the first function block, a variable corresponding to a target column is set as an argument.

5. The control system according to claim 1 , wherein the user program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

6. An control apparatus for production process automation, the control apparatus comprising control circuitry configured to access a database,

wherein the control apparatus performs operations comprising:

acquiring a column name and a data type of each column of a table, the table being selected from among one or more tables held by a database, the database being accessible to the control apparatus for production process automation;

determining a data type of each member in correspondence with the acquired data type of each column, the data type being available in the user program;

displaying a screen including the column name and the data type of each column, and the data type of each member brought into correspondence with the data type of each column; and

generating at least part of the user program based on the determined data type of each member and one or more selected items,

wherein the determining comprises determining the data type of each member based on a list showing a correspondence between a data type of a column and a data type of a member,

wherein at least one of the one or more selected items is for addition of a record into the table in the database, and

wherein the generating comprises generating the at least part of the user program including an instruction corresponding to the at least one of the one or more selected items with a value set to each member being an input element in the user program.

7. The control apparatus according to claim 6 , wherein the determining comprises determining the data type of each member from among data types available in the user program.

8. The control apparatus according to claim 6 , wherein the determining comprises determining the data type of each member in accordance with a user operation.

9. The control apparatus according to claim 6 , wherein

the user program includes a first function block for executing an instruction to control access to the database, and

in the first function block, a variable corresponding to a target column is set as an argument.

10. The control apparatus according to claim 6 , wherein the user program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

11. A non-transitory storage medium storing an information processing program for a control apparatus for production process automation, the information processing program, when executed by one or more processors, causes the one or more processors to perform at least:

acquiring a column name and a data type of each column of a table, the table being selected from among one or more tables held by a database, the database being accessible to the control apparatus for production process automation;

determining a data type of each member available in the user program in correspondence with the acquired data type of each column;

displaying a screen including the column name and the data type of each column, and the data type of each member brought into correspondence with the data type of each column; and

generating at least part of the user program based on the determined data type of each member and one or more selected items,

wherein the determining comprises determining the data type of each member based on a list showing a correspondence between a data type of a column and a data type of a member,

wherein at least one of the one or more selected items is for addition of a record into the table in the database, and

wherein the generating comprises generating the at least part of the user program including an instruction corresponding to the at least one of the one or more selected items with a value set to each member being an input element in the user program.

12. The non-transitory storage medium according to claim 11 , wherein the determining comprises determining the data type of each member from among data types available in the user program.

13. The non-transitory storage medium according to claim 11 , wherein the determining comprises determining the data type of each member in accordance with a user operation.

14. The non-transitory storage medium according to claim 11 , wherein the user program includes a first function block for executing an instruction to control access to the database, and in the first function block, a variable corresponding to a target column is set as an argument.

15. The non-transitory storage medium according to claim 11 , wherein the user program includes a second function block for storing, in the control apparatus, data of a data type brought into correspondence with the data type of each column.

Priority Claims (1)

Continuity (2)

References Cited (38)