Mitsubishi Electric MELSEC iQ-R Series - Searching the Record in the Data Base

968
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Searching the record in the data base
DBSELECT(P)
These instructions search the records in the table in the database corresponding to the specified identification number.
■Execution condition
Setting data
■Descriptions, ranges, and data types
*1 The table and field names are case-sensitive.
*2 When specifying setting data by using a label, define an array to secure enough operation area and specify an element of the array
label.
Ladder ST
ENO:=DBSELECT(EN,s1,s2,s3,s4,d1,d2,d3);
ENO:=DBSELECTP(EN,s1,s2,s3,s4,d1,d2,d3);
FBD/LD
Instruction Execution condition
DBSELECT
DBSELECTP
Operand Description Range Data type Data type (label)
(s1) Database identification number 1 to 4 16-bit signed binary ANY16
(s2) Start device for storing the table name of the database to
be searched.
*1
 Unicode string ANYSTRING_DOUBLE
(s3) Start device for storing the field name of the database to be
searched.
*1
 Word ANY16
*2
(s4) Start device for storing the search conditions (a maximum
of two conditions).
 Word ANY16
*2
(d1) Search result  Word ANY16
*2
(d2) Completion device (start device that turns on one scan
upon completion of instruction)
• (d2)+0: Completion signal
• (d2)+1: Error completion signal
 Bit ANYBIT_ARRAY
(Number of elements: 2)
(d3) Completion status
• 0000: Completed successfully
• Other than 0000: Completed with an error (error code)
 Word ANY16
EN Execution condition  Bit BOOL
ENO Execution result  Bit BOOL
RnCPU
RnENCPU
RnSFCPU RnSFCPURnPCPURnPCPU
(Standard) (Safety)
(Redundant) (Process)
(s1) (s2) (s3) (s4) (d1) (d2) (d3)
EN ENO
s1
s2
d1
d2
d3s3
s4