Appendix B Frequently Asked Questions
294
When attempting to pass information to an Excel spreadsheet, it the
following ODBC Driver Error can occur: 'The query is not updateable
because it contains no searchable columns to use as a hopeful key'. The
Excel ODBC driver cannot correctly interpret the data type of a column, if
the column in the spreadsheet contains both text and numbers.
If a spreadsheet has been set up with data directly inputted in Excel and
an attempting to write new data to the spreadsheet from CX-Supervisor
this error will occur. This is because the ODBC Driver sees different
formats in a column.
To overcome this set up the spreadsheet the data area definition to
contain only the column headings (Insert | Name | Define…).
Another problem in this area has been that the format of the data can
change from 'Number' to 'Text' (i.e. '333) formats in the cell of the
spreadsheet. The exact cause of this error is unknown, but can be
resolved by clearing the cell formats (Edit | Clear | Formats) of the
spreadsheet that will be receiving the data.
•
How does the PLC affect performance for my network type?
The charts below show how the network type affect the performance
depending on the PLC used.
Содержание 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...