![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211189.webp)
Configuring Recordsets
SECTION 12 Databases
188
This will bring up a dialog box with a list of all valid files in the 'Directory'
specified for the Connection. After choosing a file and exiting from the 'Build
SQL' dialog box the required SQL Text is built. In the above example, the file
'Tables.txt' was chosen, but this will be written as Tables#txt in the SQL Text as
most Providers do not accept the '.' character, because it is used as a
delimiter.
12-3-3 Source
The source field shows the Table name, Server Query or SQL text as selected
above which the Recordset is linked to.
12-3-3-1 Automatically open on connection
If this checkbox is ticked the Recordset will be automatically opened when the
Connection is opened. If this is unchecked, the Recordset must be open with a
script command.
12-3-4 Lock
The lock option enables the Recordset to be opened in either read only or
read/write modes, there are two type of read/write locks as defined below:
Read OnlyThe default lock is read only i.e. data cannot be changed.
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 opened.
Note:
It is more efficient to run a Server Query than an SQL query.
Note:
For Database connections all three of the above options are available, but for
Text or CSV connections only one option is available, namely 'SQL Text'. For
convenience, a facility is provided for automatically building the required SQL
Text for this type of connection. This facility is invoked from the 'Build SQL…'
button shown below:
Read Only
The default lock is read only i.e. data cannot be changed.
Pessimistic
Locks records when you start editing and releases the lock
when Update() (or Cancel()) is called, no need to worry about a
conflict with other users, but can cause records to be locked for
long periods of time preventing other users from accessing the
same records.
Содержание CX-Supervisor
Страница 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Страница 3: ...Copyright Notice 2...
Страница 16: ...15...
Страница 17: ...16...
Страница 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Страница 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Страница 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Страница 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Страница 181: ...Data Logging SECTION 11 Data Logging 180...
Страница 201: ...Examples SECTION 12 Databases 200...
Страница 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Страница 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Страница 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Страница 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Страница 271: ...Data Logging SECTION 20 Best Practices 270...
Страница 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Страница 277: ...Appendix B Frequently Asked Questions 276...
Страница 296: ...Appendix B Frequently Asked Questions 295...
Страница 297: ...Appendix B Frequently Asked Questions 296...
Страница 298: ...Appendix B Frequently Asked Questions 297...
Страница 299: ...Appendix B Frequently Asked Questions 298...
Страница 333: ...Revision history 332...