13 DATABASE FUNCTION
13.1 Specifications
235
13
Available operations
The following table lists the operations that can be performed with the database functions.
: Can be performed,
: Cannot be performed
• For details on the database access instructions, refer to the following.
MELSEC iQ-R Programming Manual (CPU Module Instructions, Standard Functions/Function Blocks)
• For the available SQL commands for the CPU module database access function, refer to the following.
Page 996 List of Available SQL Commands for CPU Module Database Access Function
• The user cannot execute multiple database access instructions simultaneously. If they are executed
simultaneously, instructions other than the first one will be completed with an error.
• Even though the operation can be performed for the database of the CPU module by the SQL command, an
error occurs on the application side when it cannot be performed in the application. In this case, check the
details of the error and perform the operation within the range of the specifications of the application again.
Operation
Description
Database access instruction
CPU module database
access function
Availability and instruction
symbol
Availability and application
Database
Connection
Connects to the specified database.
DBOPEN(P)
Microsoft Access
,
Excel
, user-created
application
Disconnection
Disconnects from the specified database.
DBCLOSE(P)
Import
Imports the specified data from the
specified Unicode text file to create a
database.
DBIMPORT(P)
Export
Exports the specified data in the specified
database into a Unicode text file.
DBEXPORT(P)
Table
Add
Adds a table to the database.
Microsoft Access
Record
Access
Accesses the specified table in the
database.
Microsoft Access
Add
Adds a record to the specified table of the
database.
DBINSERT(P)
Microsoft Access
Update
Updates the value of the specified record
on the specified table in the database.
DBUPDATE(P)
Microsoft Access
Acquire
(Search)
Acquires the value of the specified record
on the specified table in the database.
DBSELECT(P)
Excel
Delete
Deletes the specified record on the
specified table in the database.
DBDELETE(P)
Microsoft Access
Transaction
Start
Starts a transaction for the specified
database.
DBTRANS(P)
Microsoft Access
(The
transaction range depends
on the application.)
Commit
Commits a transaction for the specified
database.
DBCOMMIT(P)
Microsoft Access
(The
transaction range depends
on the application.)
Rollback
Performs rollback on the specified
database.
DBROLBAK(P)
Microsoft Access
(The
transaction range depends
on the application.)
Database operation by a desired SQL
User-created application
Содержание MELSEC iQ-R-R00CPU
Страница 2: ......
Страница 151: ...9 MONITOR FUNCTION 9 1 Real Time Monitor Function 149 9 MEMO ...
Страница 323: ...18 SEQUENCE SCAN SYNCHRONIZATION SAMPLING FUNCTION 321 18 MEMO ...
Страница 330: ...328 20 ROUTING SETTING 20 3 Precautions MEMO ...
Страница 423: ...26 BASIC CONCEPT 26 8 State Transition of the Redundant System 421 26 MEMO ...
Страница 524: ...522 30 MAINTENANCE AND INSPECTION FOR A REDUNDANT SYSTEM 30 1 Module Replacement in the Redundant System MEMO ...
Страница 1009: ...APPX Appendix 14 List of Available SQL Commands for CPU Module Database Access Function 1007 A MEMO ...
Страница 1014: ...1012 APPX Appendix 15 Added and Enhanced Functions MEMO ...
Страница 1027: ......