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
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:=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.
Unicode string
ANYSTRING_DOUBLE
(s3)
Start device for storing the field name of the database to be
updated.
Word
ANY16
(s4)
Start device for storing the updated data
Word
ANY16
(s5)
Start device for storing the update conditions (a maximum
of two conditions).
Word
ANY16
(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 RnSFCPU
RnPCPU
RnPCPU
(Standard)
(Safety)
(Redundant)
(Process)
(s1)
(s2)
(s3)
(s4)
(s5)
(d1)
(d2)
EN
ENO
s1
s2
d1
d2
s3
s4
s5
Содержание MELSEC iQ-R Series
Страница 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Страница 2: ......
Страница 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Страница 34: ...32 MEMO ...
Страница 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Страница 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Страница 204: ...202 5 SEQUENCE INSTRUCTIONS 5 3 Output Instructions Operation error There is no operation error ...
Страница 470: ...468 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 472: ...470 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 479: ...6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions 477 6 Operation error There is no operation error ...
Страница 504: ...502 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 518: ...516 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 520: ...518 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 754: ...752 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 756: ...754 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 758: ...756 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 760: ...758 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 895: ...7 APPLICATION INSTRUCTIONS 7 16 Ramp Signal Instruction 893 7 Operation error There is no operation error ...
Страница 917: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 915 7 Operation error There is no operation error ...
Страница 919: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 917 7 Operation error There is no operation error ...
Страница 1415: ...13 SFC PROGRAM INSTRUCTIONS 13 1 SFC Control Instructions 1413 13 Operation error There is no operation error ...
Страница 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Страница 1795: ...25 TYPE CONVERSION FUNCTIONS 25 1 Converting BOOL to WORD 1793 25 Operation error There is no operation error ...
Страница 1805: ...25 TYPE CONVERSION FUNCTIONS 25 10 Converting WORD to DINT 1803 25 Operation error There is no operation error ...
Страница 1819: ...25 TYPE CONVERSION FUNCTIONS 25 21 Converting INT to DWORD 1817 25 Operation error There is no operation error ...
Страница 1950: ...1948 32 STRING FUNCTIONS 32 2 Extracting String Data From the Left Right Operation error There is no operation error ...
Страница 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Страница 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Страница 2082: ...2080 APPX Appendix 6 Process Control Program Examples 129 Set the default value of the loop tag ...
Страница 2093: ...APPX Appendix 7 List of Loop Tag Memory Areas Used by Process Control Instructions 2091 A MEMO ...
Страница 2109: ......