Omron NX701-1620 User Manual

Appendix A
A-44
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
 Sample Programming
- Establish a DB Connection named MyDatabase1 and map a table with a variable.
Check the completion of DB_Connect and DB_CreateMapping instructions.
DB_CreateMapping
_Select_instance.Done
OperatingEnd_Connect
DB_Connect_instance.Error
DB_CreateMapping_Select
_instance.Error
Accept the trigger for establishing the DB Connection.
Trigger_Connect
Operating_Connect
_DBC_Status.Run
RS_Connect_instance
OperatingEnd_Connect
Set
Reset1
RS
Q1
Establish the DB Connection named MyDatabase1.
Operating_Connect
DB_Connect_instance
‘MyDatabase1’
Execute
DBConnectionName
DB_Connect
Done
Busy
Error
ErrorID
DBConnection
MyDB1
Map the variable MapVar_Select to the table Production of the DB Connection MyDB1 for the SELECT operation.
DB_Connect_instance.Done
DB_CreateMapping
_Select_
instance
MyDB1
‘Production’
MapVar_Select
_DBC_SQLTYPE_SELECT
Execute
DBConnection
TableName
MapVar
SQLType
DB_CreateMapping
Done
Busy
Error
ErrorID
When the instruction is terminated due to an error, execute the error handler for the device (FaultHandler_Connect).
Program the FaultHandler_Connect according to the device.
Operating_Connect
DB_Connect_instance.Error
DB_CreateMapping_Select_instance.Error
EN
FaultHandler_Connect
FaultHandler_Connect

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English