Mitsubishi Electric MELSEC iQ-R Series - Deleting the Record in the Data Base

976
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Deleting the record in the data base
DBDELETE(P)
These instructions delete the record that meets the specified condition in the specified table in the database corresponding to
the specified identification number.
■Execution condition
Setting data
■Descriptions, ranges, and data types
*1 The table 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:=DBDELETE(EN,s1,s2,s3,d1,d2);
ENO:=DBDELETEP(EN,s1,s2,s3,d1,d2);
FBD/LD
Instruction Execution condition
DBDELETE
DBDELETEP
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 table name of the database to
be deleted.
*1
 Unicode string ANYSTRING_DOUBLE
(s3) Start device for storing the deletion conditions (a maximum
of two conditions).
 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) (d1) (d2)
EN ENO
d1
d2
s1
s2
s3