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
*1
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.
=33n
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.)
To Next Page
Loading...
