Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Displaying data in trend from SQL tabel

Created by: Kruno at: 2/22/2011 2:07 PM (5 Replies)

Rating (0)

Thanks 1

6 Entries

2/22/2011 2:07 PM	Rate (0)
Kruno Posts: 6 Rating: (0)	I have problem displaying data in trend view, which is stored in SQL tabel. I have used this exampel fordisplaying datain trend viewhttp://support.automation.siemens.com/WW/llisapi.dll/44240726?func=ll&objId=44240726&objAction=csView&mlfbclusterid=34502091&nodeid0=16502685&lang=en&siteid=cseus&aktprim=0&extranet=standard&viewreg=WW&load=content&prodLstObjId=27037340&start=11&csSort=-DOCDATUMBEITRAG&subtype=133000 The code is from exampel, and is adopted to my project (tag names, vars..) In MS SQL managment studio i can see that i have sucssesfully copied data to new tabel. As i have to, to display it in new trend. But WinCC is simply not displaying this data. On Y-axis evrything is ok. Time is rearanged well, according to loaded tabel. But on X-axis there is nothing! Could you please suggest me what might be wrong. As i said, tabel is created but not displayed in trend view! TY!
Kruno Posts: 6 Rating: (0)
Suggestion To thank Quote Answer

2/22/2011 3:26 PM	Rate (0)
Sandman Platinum Member Joined: 4/29/2010 Last visit: 1/20/2025 Posts: 1557 Rating: (161)	Hello, can you post a screenshot of your trend settings. best regards.

Suggestion To thank Quote Answer

2/22/2011 5:25 PM	Rate (0)
Kruno Posts: 6 Rating: (0)	Hi, Here are my settings Attachment Trend.zip (547 Downloads)
Kruno Posts: 6 Rating: (0)
Suggestion To thank Quote Answer

2/22/2011 6:52 PM	Rate (0)
Kruno Posts: 6 Rating: (0)	Sorry On X-axis evrything is ok. Time is rearanged well, according to loaded tabel. But on Y-axis there is nothing! Here is my code: Dim conn,rst, SQL, TabName, Variable_Time, Variable_Date, Message_Text_01 'Building up connection to the database Set conn = CreateObject("ADODB.Connection") Set rst = CreateObject("ADODB.Recordset") 'DSN = Name of the ODBC database conn.Open "Provider=MSDASQL;DSN=WinCCflexible" 'Set the Message text, in this sample in german Message_Text_01 = "Error!" 'Error handling On Error Resume Next Err.Clear 'Target: dbo = Key word -> DataBaseOwner TabName = "[Klor0_" & SmartTags("Selection_Year") & "_" & SmartTags("Selection_Month") & "].dbo." TabName = TabName & "Klor0_" & SmartTags("Selection_Year") & "_" & SmartTags("Selection_Month") & "_" & SmartTags("Selection_Day") 'Read the selected values from the table SQL = "SELECT From" & TabName conn.execute(SQL) 'Elected tabel available? -> System message If Err.Number <> 0 Then ShowSystemAlarm Message_Text_01 Else 'Table available, delete old entries from the archive file SQL = "DROP TABLE Prikaz0" Set rst = conn.Execute(SQL) End If 'Target: dbo = Key word -> DataBaseOwner TabName = "[Klor0_" & SmartTags("Selection_Year") & "_" & SmartTags("Selection_Month") & "].dbo." TabName = TabName & "Klor0_" & SmartTags("Selection_Year") & "_" & SmartTags("Selection_Month") & "_" & SmartTags("Selection_Day") 'Over the text lists selected archive copy to the archive "Data_Logs_Trend_View" SQL = "SELECT * INTO Prikaz0 FROM " & TabName conn.execute(SQL) 'Stop connection to the database conn.Close 'Clear memory Set rst = Nothing Set conn = Nothing 'Set the "Trend view" to the selected time Variable_Date = SmartTags("Selection_Day") & " " & SmartTags("Selection_Month") & " " & SmartTags("Selection_Year") Variable_Time = "12:30:00" ' Durch die Vorgabe der "Minute" (30) wird die Mitte der Stunde in der Kurvenanzeige angezeigt 'Variable_Time = SmartTags("Selection_Hour") & ":30:00" ' Durch die Vorgabe der "Minute" (30) wird die Mitte der Stunde in der Kurvenanzeige angezeigt SmartTags("TrendView_ExternalTime") = CDate(Variable_Date & " " & Variable_Time) Attachment MS SQL Manager.JPG (556 Downloads)
Kruno Posts: 6 Rating: (0)
Suggestion To thank Quote Answer

2/23/2011 4:01 PM	Rate (0)
Krunoslav Posts: 3 Rating: (0)	Anyone pls. Tabel is created. Trend is referenced to tabel but not disolaying anything. Someone, please help!
Krunoslav Posts: 3 Rating: (0)
Suggestion To thank Quote Answer

7/21/2021 10:34 AM	Rate (0)
Levi007 Regular Member Joined: 4/18/2017 Last visit: 1/31/2025 Posts: 7 Rating: (0)	Hi! I encountered a similar problem. The solution was that WinCC first created an SQL database to establish a connection between the Wincc runtime and the database table, and then I checked the table name with SQL Server Management Studio and loaded the data into it. So WinCC has already seen it and read it back. Best Regards Levente

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Jen_Moderator

|

Share this page:

Share this page on...

Follow us on