962
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Updating the record in the data base
DBUPDATE(P)
These instructions update all records that meet the specified condition in the specified table corresponding to the specified
identification number.
■Execution condition
■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:=DBUPDATE(EN,s1,s2,s3,s4,s5,d1,d2);
ENO:=DBUPDATEP(EN,s1,s2,s3,s4,s5,d1,d2);
FBD/LD
Instruction Execution condition
DBUPDATE
DBUPDATEP
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
table to be updated.
*1
Unicode string ANYSTRING_DOUBLE
(s3) Start device for storing the field name of the database to be
updated.
*1
Word ANY16
*2
(s4) Start device for storing the updated data Word ANY16
*2
(s5) Start device for storing the update 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) (s4) (s5) (d1) (d2)
To Next Page
Loading...
