That’s where I’m a bit foggy to begin with.
I know that I want to take the values from 4 columns within one row of the database. I have the query written which gives me the values I want to use. However I’m uncertain the rules of how the data must be handled in order to get those values into OPC tags, must they be written to OPC tags?
I’m essentially wanting to turn the values read from the database into Database Tags. Which is what I’m doing now, but it requires sending 32 queries to the database everytime I update the tags. 4 values from each row, for 8 different peices of equipment. 4x8
I was thinking that perhaps there would be a simple way to run the query once per peice of equipment to pull the 4 values I need, taking those 4 values and storing them as DB Tags. In return taking me from 32 queries to only 8.
I don’t have any OPC tag addresses setup as of yet to utilize for this so I am completely open to any suggestions. I do have DB Tags setup in the current project for pulling the values I need resulting in the 32 queries on every update.