960
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Processing details
• These instructions add a record to the table specified by (s2) in the database corresponding to the identification number
specified by (s1).
• Specify the number of fields of the record to be added and field names in (s3). For the field names to be added, not all fields
making up the table need to be specified. NULL is stored in a field which is not specified.
• Specify the number of records to be added and the size and value per record in (s4).
• The following figure shows an example when a record is added to the table recipeA by using the DBINSERT(P) instruction.
• Upon successful completion, the completion signal in the completion device (d1)+0 is turned on and 0 is stored as the
completion status in the device (d2).
• Upon completion with an error, the error completion signal in the completion device (d1)+1 is turned on and an error code is
stored as the completion status in the device (d2).
• The following figure shows the operation of the completion device at completion of the DBINSERT(P) instruction.
• SM753 (File being accessed) turns on while the DBINSERT(P) instruction is executed.
*2
While SM753 is on, the
DBINSERT(P) instruction cannot be executed. If executed, no processing is performed. However, the instruction has been
completed with an error while the database access instruction is being executed.
• When "To Use or Not to Use the Built-in Database Access" is set to "Use" in the module parameter of the CPU module, the
DBINSERT(P) instruction cannot be executed while SM1498 (CPU module database start-up flag) is off.
*2
If executed, no
processing is performed.
*2 For the firmware versions supporting SM753 and SM1498, refer to the list of special relay areas. (
MELSEC iQ-R CPU Module
User's Manual (Application))
(1) Field 1: WORD
(2) Field 2: WSTRING (16 characters maximum)
(3) Field 3: INT
1
2
ProductA
100
ProductB
200
(1)
(2)
(3)
OFF
OFF
ON
ON
Program
DBINSERT(P) instruction
END processing
END processing
Adding data to
the database
Completion device (d1)
Completion device (d1)+1
END processing
Error completion
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: ......