Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 972

■Search condition
Operand: (s4)
Device Item
+0 Data size of the first
condition
+1 Data size of the
second condition
+2 Maximum output
size
+3 Maximum number
of outputs
+4 to + Search condition
*1 "0" to "3072" for a programmable controller CPU with firmware version earlier than "28"
7 APPLICATION INSTRUCTIONS
970
7.21 Database Access Instructions
Description
Set the data size of the first search condition in units of words in (s4)+4. If 0 is
set in (s4), all records in the table are to be output.
• 0: No condition
• Other than 0: Data size of field
(When (s4) is set to 0, set (s4)+1 also to 0.)
Set the data size of the second search condition in (s4)+4.
• 0: No condition
• Other than 0: Data size of field
Set the maximum output size in the search result (d1).
• 0: Default value (1024 words)
Set the maximum number of outputs in the search result (d1).
• 0: Default number of outputs (16 outputs)
Set the search conditions. The last address in (s4) varies depending on the data
type of the determination value.
(s4)+4
(1)
(s4)+35
(s4)+36 (2)
(s4)+37
(3)
(s4)+38
(4)
(s4)+
■Field name (1)
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.
■Condition number (2)
Set the number indicating a search condition.
• 1: = (Equal to the determination value)
• 2: != (Other than the determination value)
• 3: < (Smaller than the determination value)
• 4: > (Greater than the determination value)
• 5: =< (Equal to or less than the determination value)
• 6: >= (Equal to or greater than the determination value)
• 7: is NULL (NULL (no value is set))
• 8: is not NULL (Not NULL (a value is set))
■Logical operator setting value (3)
Set the operator with an adjacent condition.
• 0: No operator
• 1: AND
• 2: OR
When one search condition is specified, set the logical operator setting value of
the first search condition to 0. In this case, the second search condition is
ignored if specified.
Be sure to set the logical operator setting value of the second update condition
to 0.
■Determination value (4)
Set the value used to determine the update condition.
Also when the condition number is 7 or 8, prepare a determination value area for
the data size.
Setting Set by Data
range type
0 to 125 User WORD
0 to 125 User
0 to User
*1
32768
0 to 64 User

User