Omron NX701-1620 - Db_Insert (Insert DB Record

Appendix A
A-14
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB_Insert (Insert DB Record)
The DB_Insert instruction inserts values of a DB Map Variable to a table of the connected DB as a
record.
Instruction
Name
FB/FUN
Graphic expression
ST expression
DB_Insert Insert DB
Record
FB DB_Insert_instance (Execute,
DBConnection, MapVar,
TimeOut, Done, Busy, Error,
ErrorID, SendStatus);
Note The DB_Insert_instance is an instance of DB_Insert 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
--- 16#0000
0000
Specify the DB Connection established
by a DB_Connect instruction.
MapVar DB Map
Variable
Structure Depends on the
data type.
--- --- Specify the DB Map Variable mapped
by a DB_CreateMapping instruction.
TimeOut Timeout TIME T#0s,
T#0.05s to
T#180s
--- T#0s Specify the time to detect timeout.
When T#0s is specified, timeout is not
monitored.
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.
SendStatus Send
Status
_eDBC_SEND_STATUS Depends on
the data type.
--- Outputs the progress of transmission of the SQL
statement.
DB_Insert
DBConnection Busy
Execute
Done
Error
ErrorID
MapVar
SendStatus
TimeOut
DB_Insert_instance