VERSION 6
|
|
Database Querying From WinCC
|
This example WinCC project demonstrates the basic SQL and ADO commands to query and manipulate a database using VBS.
download
|
|
ComboBox Example
|
Example showing how to populate the Combo Box Control using a VBS script. It also writes the value and index of the item selected to internal tags. Using this method, one can detect which item has been selected and act accordingly.
download
|
VERSION 5
|
|
Query WinCC Data From Excel
|
This is a simple Excel2000 spreadsheet that demonstrates how to query WinCC historical data in Excel. It uses VBA scripts with ADO objects to connect and query the WinCC databases.
download
|
|
Export to Excel
|
A simple WinCC v5 project that exports data from multiple archives to a CSV file.
This application was developed in response to a customer request but may prove useful
to others who need similar functionality.
The project queries the WinCC runtime database using ADO scripts to populate an
ADO recordset and then writes the data to a CSV file
download
|
|
Database Querying From WinCC
|
This example WinCC project demonstrates the basic SQL and ADO commands to query
and manipulate a database using C scripts.
download
|
|
List Box Example
|
This is a WinCC PDL page that shows how you can use the standard Microsoft Forms ListBox in WinCC.
It is a nice example of how to call methods of an ActiveX control from WinCC using C scripts.
download
|
|
Export Alarms
|
Here are two example VBScript files that export the alarm data from your WinCC project to generate a report.
There are two files, one which will generate a formatted HTML report and the second that creates either a CSV or XLS file (depending on whether or not you have Excel installed). Please remember to open the files and change the ODBC Data Source Name to match that of your project.
As always, these are just examples to help you get started.
download
|
|
WinCC & MSAccess
|
The purpose of this project is to demonstrate how WinCC can interact with a database.
I have used an MS Access database in this example because it is easily portable
download
|