baref00t25
Member
We have an application where we are storing information about the product that this machine makes. The data we are storing are marks on the product so the operator can see where the marks are on the roll of material so they can cut that section out. Each "mark" has roughly 20 values associated with it (date,time,size,x position, y position, picture file path, etc.)
We are getting the data into SQL through Wonderware and we can retrieve the data for viewing, but only one at a time on the screen. We could potentially make 16 seperate connections to the database and display upto 16 data points, but would prefer to display 30 - 50 "marks" at once so that we could print it. So far the only way we can see doing this is to painfully load thesee manually one at a time into memory variables which could be up to 1000 variables if we do 50 "marks".
Are there any other ways that someone could think of? Maybe loading it into a .csv or .xls file and then displaying?
We are getting the data into SQL through Wonderware and we can retrieve the data for viewing, but only one at a time on the screen. We could potentially make 16 seperate connections to the database and display upto 16 data points, but would prefer to display 30 - 50 "marks" at once so that we could print it. So far the only way we can see doing this is to painfully load thesee manually one at a time into memory variables which could be up to 1000 variables if we do 50 "marks".
Are there any other ways that someone could think of? Maybe loading it into a .csv or .xls file and then displaying?