7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
961
7
Precautions
In the following cases, the error completion signal in (d1)+1 is turned on and an error code is stored as the completion status
in the device (d2).
• The DBINSERT(P) instruction is executed during execution of the database access instruction.
• An identification number outside the range is specified by (s1).
• An identification number of a database which is not open is specified by (s1).
• A database built or operated with a programmable controller CPU with firmware version "28" or later is specified by (s1) for
a programmable controller CPU with firmware version earlier than "28".
• The table name specified by (s2) does not exist.
• The number of characters of the table name specified by (s2) exceeds 32.
• An out-of-range value is specified in (s3) for the number of fields to be added.
• An out-of-range field name is set in the field name specified by (s3)+1 to (s3)+
.
• An out-of-range value is specified in (s4) for the number of records to be added.
• Database insertion processing failed.
• The range of the data for one record set in (s4)+2 does not match the size specified by (s4)+1.
Operation error
For the error code stored in the completion status of the operand, refer to the following.
Page 986 Error codes related to database access instructions
Error code
(SD0)
Description
2820H
The area specified by (s2), (s3), (s4), or (d1) exceeds the applicable range of the device/label used.
Summary of Contents for MELSEC iQ-R Series
Page 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Page 2: ......
Page 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Page 34: ...32 MEMO ...
Page 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Page 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Page 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Page 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Page 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Page 2109: ......