Mitsubishi Electric MELSEC iQ-R Series - Page 968

966
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Processing details
• Updates all record that meets the condition specified by (s5) in the table specified by (s2) in the database specified by the
identification number specified by (s1).
• Specify the field name of the record to be updated in (s3). Not all fields in the table need to be specified but at least one field
needs to be specified.
• Specify the value of the record to be updated in (s4). The set value in any field not specified in (s3) is not updated.
• Specify the condition to be updated in (s5). At least one condition needs to be specified and a maximum of two conditions
can be specified.
• When the DBUPDATE(P) instruction updates the table recipeA record that matches "field1="2" of the update condition in
which the update target field name is 2 and the updated data is New-Product1, the following occurs.
• When the DBUPDATE(P) instruction updates the table recipeA record that matches "field1>="2" and field1<=3 of the
update condition in which the update target field name is 2 and the updated data is New-Product1, the following occurs.
• 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).
1
2
3
ProductA 100
ProductB 200
ProductC 300
1
2
3
ProductA 100
New-Product1 200
ProductC 300
Field 1
WORD
Field 2
WSTRING
(16 characters maximum)
Field 3
INT
Table recipeA (before update)
Field 1
WORD
Field 2
WSTRING
(16 characters maximum)
Field 3
INT
Table recipeA (after update)
1
3
4
ProductA 100
2 ProductB 200
ProductC 300
ProductD 200
1
3
4
ProductA 100
2 New-Product1 200
New-Product1 300
ProductD 400
Field 1
WORD
Field 2
WSTRING
(16 characters maximum)
Field 3
INT
Table recipeA (before update)
Field 1
WORD
Field 2
WSTRING
(16 characters maximum)
Field 3
INT
Table recipeA (after update)