2 CPU MODULE INSTRUCTIONS
2.3 Application Instructions
111
2
■
Calculating the mean value of 16-bit/32-bit binary data
■
Calculating the square root of 16-bit/32-bit binary data
■
CRC operation
Database access instructions
■
Opening the database
■
Closing the database
■
Adding a record to the database
■
Updating the record in the database
■
Searching the record in the database
■
Deleting the record in the database
Instruction symbol
Processing details
Reference
MEAN
Calculates the average value of the (n) points of 16-bit data in the device starting from the one
specified by (s), and stores the average value in the device specified by (d).
MEANP
MEAN_U
MEANP_U
DMEAN
Calculates the average value of the (n) points of 32-bit data in the device starting from the one
specified by (s), and stores the average value in the device specified by (d).
DMEANP
DMEAN_U
DMEANP_U
Instruction symbol
Processing details
Reference
SQRT
Performs a square root operation of the specified 16-bit binary data.
(s)
(d)
SQRTP
DSQRT
Performs a square root operation of the specified 32-bit binary data.
(s)+1, (s)
(d)
DSQRTP
Instruction symbol
Processing details
Reference
CRC
Generates the CRC value for (n) 8-bit data (unit: byte) starting from the device specified by (s), and
store the CRC value to the device specified by (d).
CRCP
Instruction symbol
Processing details
Reference
DBOPEN
Connects to the database specified by (s), and makes it available.
DBOPENP
Instruction symbol
Processing details
Reference
DBCLOSE
Releases the identification number specified by (s) and the allocation of the database.
DBCLOSEP
Instruction symbol
Processing details
Reference
DBINSERT
Adds a record to the table specified by (s2) in the database corresponding to the identification
number specified by (s1).
DBINSERTP
Instruction symbol
Processing details
Reference
DBUPDATE
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).
DBUPDATEP
Instruction symbol
Processing details
Reference
DBSELECT
Searches the records in the table specified by (s2) in the database corresponding to the
identification number specified by (s1).
DBSELECTP
Instruction symbol
Processing details
Reference
DBDELETE
Deletes the record that meets the condition specified by (s3) in the table specified by (s2) in the
database corresponding to the identification number specified by (s1).
DBDELETEP
Содержание 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: ......