Omron NX701-1620 - Db_Delete (Delete DB Record

Appendix A
A-39
A
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
DB_Delete (Delete DB Record)
DB_Delete (Delete DB Record)
The DB_Delete instruction deletes the records that match the conditions from a specified table.
Instruction
Name
FB/FUN
Graphic expression
ST expression
DB_Delete Delete DB
Record
FB
DB_Delete_instance (Execute,
DBConnection, TableName,
Where, TimeOut, Done, Busy,
Error, ErrorID, RecCnt);
Note The DB_Delete_instance is an instance of DB_Delete 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.
TableName Table Name STRING Depends on the
data type.
--- '' Specify a table name in the DB.
Where Retrieval
Conditions
STRING 1,986 bytes max.
(including the final
NULL character)*
--- '' Specify a text string that expresses
retrieval conditions (WHERE clause).
(‘WHERE’ is not included.)
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.
* When the database is case sensitive, specify the column name as shown below.
When connecting to MySQL, enclose the column name in single-byte backquotes
Example: `ColumnA`
When connecting to other databases, enclose the column name in single-byte double quotes.
Example: “ColumnA”
DB_Delete
DBConnection
Busy
Execute
Done
Error
ErrorID
TableName
Where
TimeOut
RecCnt
DB_Delete_instance
DB Connection Instructions