7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
957
7
■
Applicable devices
■
Database field name
*1 Programmable controller CPU with firmware version "28" or later supports this processing.
*2 "1" to "16" for a programmable controller CPU with firmware version earlier than "28"
The following figure shows the format of (s3).
Operand
Bit
Word
Double word Indirect
specification
Constant
Others
X, Y, M, L,
SM, F, B, SB,
FX, FY
J
\
T, ST, C, D, W,
SD, SW, FD, R,
ZR, RD
U
\G
, J
\
,
U3E
\(H)G
Z
LT, LST,
LC
LZ
K, H E
$
(s1)
(s2)
(s3)
(s4)
(d1)
(d2)
Operand: (s3)
Device
Item
Description
Setting range
Set by
+0
Number of fields
Specify the number of fields to which a value is to be added.
Specify a value equal to or less than the number of fields of the table specified in (s2).
If 0 is specified, all fields of the table are subject to output.
0 to 128
User
+1 to +
Field name
Specify the name of each field. Specify field names, each fixed to 32 characters, by
the number of fields with Unicode character strings. For the name less than 32
characters, the character string should be right-justified and filled with 0000H to
become a 32-character string.
The last address
in (s3) varies according to the number of fields.
=32
n (n: Number of fields)
This setting of this item is not necessary when "0" is specified in (s3)+0.
(Ignored if
specified.)
User
b15
b0
∙∙∙
(s3)+1
(s3)
(s3)+32*n
(s3)+32
∙∙∙
n
1
Set the number of fields, 'n'.
A field name set in the 1st field
A field name set in the 'n'th field
Data for 'n' fields (If zero is
set to (s3), setting for these
data is not required.)
Содержание 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: ......