As i am new to Factory talk transaction manager.I am using the Factory talk transaction manager for logging the RS View 32 data to SQL server 2005.I have configured it and able to log the data in SQL server columns but my issue is i have to log the array of tags(60) into one praticular coulumn in SQL server database.So how can configure the transactions in Transaction Manager.
Array of tags in Rs View 32 to SQL server database through transaction manager
- Thread starter ALT
- Start date
I haven't used Rssql in a while, but I think there are two ways.
One is specifying each array sub element in the transaction, like
MyArray(20), another way might be to pass the whole array as one item to SqlSvr, but instead of binding to a table, you have to create a stored procedure.
The stored procedure would then have to extract each array element, and issue insert statements for each item.
That's all I can remember, Hope it's correct.
One is specifying each array sub element in the transaction, like
MyArray(20), another way might be to pass the whole array as one item to SqlSvr, but instead of binding to a table, you have to create a stored procedure.
The stored procedure would then have to extract each array element, and issue insert statements for each item.
That's all I can remember, Hope it's correct.
Similar Topics
Hello,
I have a WinCC Flexible Runtime which gets data from a SQL 2005 Express.
Now i want to view a complete table (40 lines, 10 elements...
I'm using the latest Rockwell CCW to program a Micro 850 and Panelview PV800 - 2711R HMI.
I'm having difficulties getting the Panelview HMI tags...
Hello,
I am new to plc programming and looking for why we use Array of Tags and if i can get some practical examples?
I was unable to find an answer while searching, so I decided to start a new thread.
I'm in the process of creating produced and consumed tags...
Hello, Everybody!
The plant I'm currently working at was programmed without any bypass capability in the RSLogix 5000, or the Wonderware HMI...
