Mitsubishi Electric MELSEC iQ-R Series - Adding a Record to the Data Base

956
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Adding a record to the data base
DBINSERT(P)
These instructions add a record to the table of the database corresponding to the specified identification number.
■Execution condition
Setting data
■Descriptions, ranges, and data types
*1 The table and field names are case-sensitive.
*2 When specifying setting data by using a label, define an array to secure enough operation area and specify an element of the array
label.
Ladder ST
ENO:=DBINSERT(EN,s1,s2,s3,s4,d1,d2);
ENO:=DBINSERTP(EN,s1,s2,s3,s4,d1,d2);
FBD/LD
Instruction Execution condition
DBINSERT
DBINSERTP
Operand Description Range Data type Data type (label)
(s1) Database identification number 1 to 4 16-bit signed binary ANY16
(s2) Start device for storing the database table names.
*1
 Unicode string ANYSTRING_DOUBLE
(s3) Start device for storing the database field names.
*1
 Word ANY16
*2
(s4) Start device for storing insertion data  Word ANY16
*2
(d1) Completion device (start device that turns on one scan
upon completion of instruction)
• (d1)+0: Completion signal
• (d1)+1: Error completion signal
 Bit ANYBIT_ARRAY
(Number of elements: 2)
(d2) Completion status
• 0000: Completed successfully
• Other than 0000: Completed with an error (error code)
 Word ANY16
EN Execution condition  Bit BOOL
ENO Execution result  Bit BOOL
RnCPU
RnENCPU
RnSFCPU RnSFCPURnPCPURnPCPU
(Standard) (Safety)
(Redundant) (Process)
(s1) (s2) (s3) (s4) (d1) (d2)
EN ENO
s1
s2
d1
d2
s3
s4