Omron NX701-1620

Appendix A
A-74
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
 Sample Programming
- Resend the SQL statements stored in the Spool memory when the status of the DB Connection is Connected.
Check the completion of the instruction.
Nosent
OperatingEnd
DB_Get
Connection
Status_instance.Error
DB_ControlSpool_instance.Done
DB_ControlSpool_instance.Error
Accept the trigger.
Trigger
Operating
RS_instance
OperatingEnd
Set
Reset1
RS
Q1
Get the status of the DB Connection.
Operating
DB_GetConnectionStatus_instance
Execute
DBConnectionName
DB_GetConnectionStatus
Done
Busy
Error
ErrorID
ConnectionStatus
MyStatus
‘MyDatabase1’
When the instruction is normally completed, change the Resend variable to TRUE if the status of the DB Connection is Connected.
Operating
DB_GetConnectionStatus_instance.Done
Resend
S
Nosent
S
_eDBC_CONNECTION_STATUS#_DBC_CONNECTION_STATUS_CONNECTED
MyStatus.Status
EN
In1
In2
=
_eDBC_CONNECTION_STATUS#_DBC_CONNECTION_STATUS_CONNECTED
MyStatus.Status
EN
In1
In2
<>