Omron NX701-1620 - Db_Select (Retrieve DB Record

Appendix A
A-34
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB_Select (Retrieve DB Record)
The DB_Select instruction retrieves records from a table to a DB Map Variable.
Instruction
Name
FB/FUN
Graphic expression
ST expression
DB_Select Retrieve DB
Record
FB
DB_Select_instance (Execute,
DBConnection, Where, Sort,
TimeOut, MapVar, Done, Busy,
Error, ErrorID, RecCnt,
SelectedCnt);
Note The DB_Select_instance is an instance of DB_Select instruction, which is declared as a variable.
Variables
Input Variables
Name Meaning
Data
type
Valid range Unit Default Description
Execute
Execute
BOOL
TRUE or FALSE
---
FALSE
Specify the execution condition.
DBConnection DB Connection DWORD 16#00000000 to
16#FFFFFFFF
--- 16#0000
0000
Specify the DB Connection established
by a DB_Connect instruction.
Where Retrieval
Conditions
STRING 1,986 bytes max.
(including the final
NULL character)*
--- '' Specify a text string that expresses
retrieval conditions (WHERE clause).
(‘WHERE’ is not included.)
Sort Sort Conditions STRING 1,986 bytes max.
(including the final
NULL character)*
--- '' Specify a text string that expresses sort
conditions (ORDER BY clause).
(‘ORDER BY’ is not included.)
TimeOut Timeout TIME T#0s,
T#0.05s to T#180s
--- T#0s Specify the time to detect timeout.
When T#0s is specified, timeout is not
monitored.
* When the database is case sensitive, specify the column name as shown below.
When connecting to MySQL, enclose the column name in single-byte backquotes
Example: `ColumnA`
When connecting to other databases, enclose the column name in single-byte double quotes.
Example: “ColumnA”
DB_Select
DBConnection Busy
Execute
Done
Error
ErrorID
MapVar
Where
SelectedCnt
RecCnt
Sort
TimeOut
DB_Select_instance