I have been given the task of reworking an old HMI setup by some outside vendors and after going through all the screens and scripts in wonderware v8.0.1 I am having some problems understanding how the bindlist is being used. I am in no way an expert in SQL but have some general knowledge...making me dangerous. Anyway there is an SQL database that has 6 different tables in it. Each table has a different amount of columns ranging from 4 to 16. In wonderware you create a bindlist to make the tags match up to the column names, but here is where I am confused. The previous creater made one bind list and uses it for every query. The bindlist has about 35 different entries that are all from one of the 6 different tables. So my questions is when the connectionID string is something like select grade from table1 where id > 3 (ignore syntax just conceptial) what happens to the other entries on the bind list? Table1 does not have the columns for all of the entries on the bindlist? I would have done a bindlist for each table so it would be easier to follow....except for when you have to do a join....sigh. Any help and guidance that could clear up my head would be greatly appreciated. If more information is needed please let me know and I will provide. Thanks in advance
