SiePortal

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

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

exporting all the analog values

9/12/2014 4:41 PM	Rate (0)
Manish C Posts: 22 Rating: (1)	Hello Josh Elliott, Can you please guide me . I want to exporting all the analog values(16bit unsigned int)to the userdefined sql database . If you have any example , Can you please share with me . Thanks in advance. Regards Manish
Manish C Posts: 22 Rating: (1)	Last edited by: Min_Moderator at: 9/16/2014 9:37 AM New subject after splitting from /tf/WW/en/Posts/113500#top#572380
Suggestion To thank Quote Answer

9/13/2014 6:26 AM	Rate (0)
Josh Elliott Posts: 204 Rating: (29)	Hi Manish C, you can use this code to export the tag values to sql database Dim conn, rst, SQL_Table On Error Resume Next Set conn = CreateObject("ADODB.Connection") Set rst = CreateObject("ADODB.Recordset") conn.Open "Provider=MSDASQL;Initial Catalog=" & "database name" & _ ";DSN=ODBC connection name" SQL_Table = "insert into table_1 values (getdate()," &_ HMIRuntime.SmartTags("NewTag") & "," &_ HMIRuntime.SmartTags("NewTag_1") & "," &_ HMIRuntime.SmartTags("NewTag_2") & "," &_ HMIRuntime.SmartTags("NewTag_3") &_ ")" Set rst = conn.Execute(SQL_Table) conn.close Set rst = Nothing Set conn = Nothing paste this in the global scriprt>VBS scriprt>acktion
Josh Elliott Posts: 204 Rating: (29)
Suggestion To thank Quote Answer

9/13/2014 1:22 PM	Rate (0)
Manish C Posts: 22 Rating: (1)	Hello Josh Thank You Very much , It is working Can you please guide me to lock Winflex Script.. Regards
Manish C Posts: 22 Rating: (1)	Last edited by: Manish C at: 9/13/2014 1:43 PM
Suggestion To thank Quote Answer

Share this page:

Share this page on...