Omron NX701-1620 - Db_Controlspool (Resend;Clear Spool Data

Appendix A
A-71
A
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB_ControlSpool (Resend/Clear Spool Data)
DB_ControlSpool (Resend/Clear Spool Data)
The DB_ControlSpool instruction resends or clears the SQL statements spooled by DB_Insert (Insert
DB Record) and DB_Update (Update DB Record) instructions.
Instruction
Name
FB/FUN
Graphic expression
ST expression
DB_ControlSpool Resend/Clear
Spool Data
FB
DB_ControlSpool_instance
(Execute, DBConnection,
Cmd, Done, Busy, Error,
ErrorID);
Note The DB_ControlSpool_instance is an instance of DB_ControlSpool 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
--- --- Specify the DB
connection established
by a DB_Connect
instruction.
Cmd Command _eDBC_SPOOL
_CMD
_DBC_SPOOL_CLEAR(1):
Clear
_DBC_SPOOL_RESEND(2):
Resend
0 Specify the command to
execute
Output Variables
Name
Meaning
Data type
Valid range
Unit
Description
Done Done BOOL TRUE or
FALSE
--- TRUE when the instruction is normally
completed.
Busy Executing BOOL TRUE or
FALSE
--- TRUE when the instruction is being executed.
Error Error BOOL TRUE or
FALSE
--- TRUE when the instruction is terminated due to
an error.
ErrorID Error Code WORD 16#0000 to
16#FFFF
--- Contains the error code when an error occurs.
DB_ControlSpool
DBConnection
Busy
Execute
Done
Error
ErrorID
Cmd
DB_ControlSpool_instance
DB Connection Instructions