Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

DateTime range in WInCC Reports

Created by: Sam. at: 5/28/2007 1:51 PM (3 Replies)

Rating (0)

Thanks 0

4 Entries

5/28/2007 1:51 PM	Rate (0)
Sam. Posts: 63 Rating: (0)	Hi experts, I am using the WinCC V6SP4. My question is how to query the data available in database for specified time range either in WinCC Reports or via Microsoft Excel/Access (if using Connectivity Pack) ? Shri
Sam. Posts: 63 Rating: (0)
Suggestion To thank Quote Answer

5/28/2007 4:54 PM	Rate (0)
Nemo Posts: 3149 Rating: (171)	Hi well, I think on connectivitypack CD there should be some examples and perhaps this site provide some examples http://wincc.net/ nemo
Nemo Posts: 3149 Rating: (171)
Suggestion To thank Quote Answer

6/7/2007 9:22 AM	Rate (0)
Sam. Posts: 63 Rating: (0)	Thanks for reply. AndI have achieved the task by creating MS Excel ODBC Query File. and querying from UA RT tables. But I have written the query in windows file, and need to be execute by WinCC in runtime. I tried using C script to execute the file: Program Execute("D:\shri\Query4Temp.csv"); also i tried with .exe, but no action from wincc runtime. where "Query4Temp" is the name of window file. Waiting for reply. Thanks.
Sam. Posts: 63 Rating: (0)
Suggestion To thank Quote Answer

6/7/2007 1:22 PM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	To query the User Archives you should be using the C functions supplied with WinCC. There is one function that allows you to filter the results. Please see the manual for function reference, syntax and examples. Regards, Salma

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on