7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
969
7
■
Applicable devices
■
Search target table name
■
Search target field name
*1 "0" 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)
(d3)
Operand: (s2)
Device
Item
Description
Setting range
Set by
+0 to +
Table name
Specify the search target table name with up to 32 characters.
User
Operand: (s3)
Device
Item
Description
Setting range
Set by
+0
Number of fields
Specify the number of fields to be searched.
If 0 is specified, all fields of the table are subject to output.
0 to 128
User
+1 to +
Field name
Specify each search target field name with 32 characters. The last address in (s3)
varies according to the number of fields.
=33
n
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.
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.)
Summary of Contents for MELSEC iQ-R Series
Page 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Page 2: ......
Page 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Page 34: ...32 MEMO ...
Page 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Page 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Page 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Page 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Page 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Page 2109: ......