![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213224.webp)
OMRON
CHAPTER 12 – Databases
Release 2.0
Page 201
Creating a Read/Write connection to CSV/Text file
Connections to CSV or Text files using the Provider installed with ADO version 2.0, like Excel files,
are also read only hence Records can not be added or amended. However, CSV and Text files can be
updated by converting the data into an Excel spreadsheet and accessing the file via the ODBC DSN
driver
.
This is achieved by carrying out the steps as above using the CSV/Text file instead. Note the
Excel provider is still used, and a named range in Excel must still be created.
Configuring Recordsets
The Recordset is the heart of the Database facility, it contains all of the columns and rows returned
from a specific action
.
The Recordset is used to navigate a collection of records, and update, add,
delete or modify records
.
Once a Connection has been added to the Workspace, the right menu
option ‘Add Recordset...’ will be enabled
.
Selecting this option will invoke the following dialog:
Name
A unique Recordset name will be automatically provided
.
This can be modified to provide a more
meaningful name if required.
Recordset Type
The Recordset can be 1 of 3 types:
Table Name
The Recordset is the name of an actual table in the Database.
Server Query
The Recordset is the results of a pre-defined Server Query stored in the database.
SQL Text
The Recordset is the results of an SQL query executed when the Recordset is
Summary of Contents for CX-SUPERVISOR - V2.0
Page 2: ...CX Supervisor User Manual Software Release 2 0...
Page 3: ......
Page 5: ...CX Supervisor User Manual OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor User Manual OMRON Page iv Revision 2 0...
Page 11: ...CX Supervisor User Manual OMRON Page viii Revision 2 0...
Page 13: ...CX Supervisor User Manual OMRON Page x Revision 2 0...
Page 15: ...CX Supervisor User Manual OMRON Page xii Revision 2 0...
Page 17: ...CX Supervisor User Manual OMRON Page xiv Revision 2 0...
Page 19: ...CX Supervisor User Manual OMRON Page xvi Revision 2 0...
Page 21: ...CX Supervisor User Manual OMRON Page xviii Revision 2 0...
Page 23: ......
Page 67: ......
Page 97: ......
Page 137: ...CHAPTER 7 Graphics Library OMRON Page 114 Release 2 0...
Page 183: ...CHAPTER 9 Animation OMRON Page 160 Release 2 0...
Page 215: ......
Page 263: ......
Page 269: ......
Page 274: ...OMRON CHAPTER 16 Connecting to Omron Industrial Components Release 2 0 Page 251...
Page 275: ......
Page 285: ......
Page 319: ......
Page 331: ......
Page 351: ......
Page 359: ...GLOSSARY OF TERMS CX Supervisor User Manual OMRON Page 336 Release 2 0...