I'm stuck working within the constraints of this software...
The chart needs to be available from the InfinitySPC interface which is the tool the plant has committed to.
We are using Microsoft SQL Server 2005 on Microsoft Windows Server 2003
I very well may end up with a separate provider for each test I chose to query for.
Although it seems inefficient, i've also learned alot through this process so all is not lost.
There may be one other Alternative...
We use a number of OPC providers as well.
I Could possibly query with another application and use TopServer to monitor the "addresses"
Infinity DMS OPC provider can point to those addresses/channels.
However, this would be another major learning experience for me.
I get whats going on but I haven't got much deeper than that.
Quick lesson in Infinity
(only if you are interested
*Every* Record must contain at least 3 columns including Part, Process and Test.
(There are more, not generally seen like "F_SGRP" which increments with every saved record)
Part: Generally the part you are producing
Process: The process or machines the part is being produced on
Test: The variable you wish to collect
There can be only one Part and Process but unlimitted Test.
You can also add unlimited "Descriptors" other columns which are user defined separated by groups - selected before the test which help to filter the data later
There are also precanned "Super Descriptors" which include "Lot", "Shift", "Job" which allow for a little more functionality
It's a powerful database tool. The data entry configurations are usually preconfigured by me and executed from a custom toolbar. General Operator use is beyond simple. We have about a hundred different Infinity Projects in use at that moment.