Omron NX701-1620 User Manual

Appendix A
A-29
A
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Name
Data type
Initial value
Comment
DB_Close_instance
DB_Close
---
Instance of DB_Close instruction
Trigger_Close BOOL FALSE Variable used as a trigger for closing the DB
Connection
LastTrigger_Close BOOL FALSE Variable to retain the trigger status of the
previous execution
Operating_Close BOOL FALSE The DB_Close instruction is executed when
this variable is TRUE.
OperatingStart_Close BOOL FALSE The start processing for closing the DB
Connection is executed when this variable is
TRUE.
Stage INT --- Variable that shows the status of the DB
Connection
 Sample Programming
// - Establish a DB Connection named MyDatabase1 and map a table with a variable.
// Start the sequence when the variable Trigger_Connect changes to TRUE.
IF ( (Trigger_Connect=TRUE)
AND (LastTrigger_Connect=FALSE)
AND (_DBC_Status.Run=TRUE) ) THEN
OperatingStart_Connect := TRUE;
Operating_Connect := TRUE;
END_IF;
LastTrigger_Connect:=Trigger_Connect;
// Sequence start processing
IF (OperatingStart_Connect=TRUE) THEN
// Initialize the instances of the applicable DB Connection Instructions.
DB_Connect_instance( Execute:=FALSE );
DB_CreateMapping_Insert_instance(
Execute := FALSE,
MapVar := MapVar_Insert,
SQLType := _DBC_SQLTYPE_INSERT
);
DB_CreateMapping_Update_instance(
Execute := FALSE,
MapVar := MapVar_Update,
SQLType := _DBC_SQLTYPE_UPDATE
);
Stage := INT#1;
OperatingStart_Connect := FALSE;
END_IF;
// Establish the DB Connection named MyDatabese1
DB_Update (Update DB Record)
DB Connection Instructions

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English