Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

WinCC VBScript sql query between two dates

Created by: umutorkan at: 11/2/2022 10:51 AM (2 Replies)

Rating (0)

Thanks 1

3 Entries

11/2/2022 10:51 AM	Rate (0)
umutorkan Regular Member Joined: 10/20/2019 Last visit: 12/15/2022 Posts: 13 Rating: (0)	Hello, I want to read data from sql table between two dates. Can you help me with the query that I should write to VBScript code. The value that I've tried to read is Float but there is no float in internal tag of the WINCC and I've tried this code; Dim com,record,SQLtable, DataBaseName, ErrorDesc, TableName, Val1, Val2 Set com = CreateObject("ADODB.Connection") Set record= CreateObject("ADODB.Recordset") com.open = "Provider=SQLOLEDB;Password=taskin;Persist Security Info=True;User ID=sa;Initial Catalog=voltaj;Data Source=DESKTOP-NFJCHUH\DENEME" SQLtable= "SELECT Volt12 FROM Table_5" Set record = com.Execute(SQLtable) record.MoveFirst SmartTags("HMI_Tag_4")=record.Fields(1).Value can you help me best regards.
	Last edited by: umutorkan at: 11/02/2022 14:22:30 Last edited by: umutorkan at: 11/02/2022 15:14:36
Suggestion To thank Quote Answer

11/3/2022 12:14 PM	Rate (0)
rdoliveira Gold Expert Joined: 4/26/2012 Last visit: 2/2/2023 Posts: 1215 Rating: (115)	Hello, use the WHERE and BETWEEN clause. SQLtable= "SELECT Volt12 FROM Table_5 WHERE YourDate BETWEEN '2022-07-01' AND '2022-07-31'" LINK you will have to adjust and use the correct SQL syntax, with the database, for your project dates. good luck
	Last edited by: rdoliveira at: 11/03/2022 12:21:05 Obrigado.
Suggestion To thank Quote Answer

11/4/2022 12:50 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 2/2/2023 Posts: 9695 Rating: (1301)	Hello umutorkan a float datatype in SQL should be a Real datatype in HMI -> LINK Try a real Tag. And you can ry to check if the sql statement gives back a propervalue with the systemfunction ShowSystemAlarm in the script. Then you see in the alarm view if the value comes back as you need. bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users rdoliveira

|

Share this page:

Share this page on...

Follow us on