11/11/2011 1:09 PM | |
Joined: 3/24/2009 Last visit: 8/7/2023 Posts: 406 Rating: (3) |
Hi, Actually the requirement is we have to show the tag values and alarms as table format in SQL studio. They are using the table both alarm and tag values in CMMS( Computerized management system ) using VB. The same system using AB is working fine in some other plant. So they are asking the same in our system. I am able to view the historical alarms in studio but i can't view the tag values. Help me if some one having experience in this.... I attached screen shot for alarms which was logged i table format in sql studio. Attachmentsql_1.zip (222 Downloads) |
All is well :-) |
|
5/20/2013 5:12 AM | |
Joined: 3/24/2010 Last visit: 2/29/2024 Posts: 118 Rating: (1) |
Is this already solved? I have the same problem.. Please help me. |
5/24/2013 11:29 AM | |
Posts: 52 Rating: (1) |
Hi I have little bit knoweldge of sql Please see the attachment In that 3 VB scripts are there,connect & sql insert we have to add in (project module) & Sql insert1 add in (Action). In Action u have to set trigger for Value lagin. in Sql Management studio u have to create one table in that add sql tag that i have mention in one of script(note). Attachmentsql values.zip (220 Downloads) |
Follow us on