This example WinCC project demonstrates the basic SQL and ADO commands to query and manipulate a database using VBS.

download

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

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

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

This example WinCC project demonstrates the basic SQL and ADO commands to query and manipulate a database using C scripts.

download

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

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

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