Omron NX701-1620 - Page 212

Appendix A
A-24
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_Update_instance.Done
OperatingEnd_Connect
DB_
Connect_instance.Error
DB_CreateMapping_Insert_instance.Error
DB_CreateMapping_Update_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_Insert to the table Production of the DB Connection MyDB1 for the INSERT operation.
DB_Connect_instance.Done
DB_CreateMapping_Insert_instance
MyDB1
‘Production’
MapVar_Insert
_DBC_SQLTYPE_INSERT
Execute
DBConnection
TableName
MapVar
SQLType
DB_CreateMapping
Done
Busy
Error
ErrorID