Abstract: A controller that controls a control target includes one or more processors, a memory that stores a program to be executed by the processors, a communication interface that accesses a database, and a storage device. The one or more processors is programed to generate an SQL statement in accordance with a function block defined in a user program based on configuration information that defines a correspondence relationship between a data type of the user program and a data type of the database, send the generated SQL statement to the database when the execution result of the SQL statement indicates an error, associate the SQL statement with an execution result of the SQL statement sent to the database and store the same as an error log in the storage device, and send the error log to an information processing device in response to a request.

Abstract: A control system includes an information processing device that communicates with a controller that controls a control target. The controller or the information processing device include a storage device that stores one or more SQL statements to be executed and an execution result the one or more SQL statements in association with each other as log data. The information processing device includes a display controller that displays on a display an SQL statement to be corrected that has an unsuccessful execution result; an operation unit that accepts a correction operation on the SQL statement and an execution operation; and a communication interface that sends an execution instruction to execute the corrected SQL statement to the controller upon receipt of the execution operation and to receive an execution result of the corrected SQL statement from the controller. The display controller displays an execution result of the corrected SQL statement.

Abstract: A control system for controlling a control target includes a database that holds one or more tables, a control apparatus that accesses the database, and an information processing apparatus that supports development of a user program executed in the control apparatus. The information processing apparatus acquires a column name and a data type of each column of a table, the table being selected from among the one or more tables, determines 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, and displays 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.

Abstract: A controller that controls a control target includes one or more processors, a memory that stores a program to be executed by the processors, a communication interface that accesses a database, and a storage device. The one or more processors is programed to generate an SQL statement in accordance with a function block defined in a user program based on configuration information that defines a correspondence relationship between a data type of the user program and a data type of the database, send the generated SQL statement to the database when the execution result of the SQL statement indicates an error, associate the SQL statement with an execution result of the SQL statement sent to the database and store the same as an error log in the storage device, and send the error log to an information processing device in response to a request.

Abstract: A controller for controlling a control object includes a communication interface, an instruction executor, and an access processor. The communication interface accesses a database device. The instruction executor executes a user program including an access instruction for accessing the database device, the user program being associated with control of the control object. The access processor generates an access request in response to execution of the access instruction and causes the communication interface to transmit the access request. The access processor extracts an access request satisfying a prescribed condition from an error list including access requests recorded when access to the database device fails and causes the communication interface to retransmit the access request extracted.

Abstract: A control system includes an information processing device that communicates with a controller that controls a control target. The controller or the information processing device include a storage device that stores one or more SQL statements to be executed and an execution result the one or more SQL statements in association with each other as log data. The information processing device includes a display controller that displays on a display an SQL statement to be corrected that has an unsuccessful execution result; an operation unit that accepts a correction operation on the SQL statement and an execution operation; and a communication interface that sends an execution instruction to execute the corrected SQL statement to the controller upon receipt of the execution operation and to receive an execution result of the corrected SQL statement from the controller. The display controller displays an execution result of the corrected SQL statement.

Abstract: A control system includes a database configured to hold one or more tables, and a control apparatus configured to execute a control program and access the database. The control system acquires a number of columns of a table and a data type of each column, the table being selected from among the one or more tables. The control system defines a structure that includes a number of members corresponding to the acquired number of columns and that is available in the control program. The control system determines a data type of each member of the structure in correspondence with the acquired data type of each column.