Hello,
I want to query a database and get one value from it.
I have the query I want working in microsoft sql server management. It is;
selecttop 1 [unknown value] from database where [known value] ='0002971465' orderby [DATE_TIME] desc
I have examples of how this database is connected to in wonderware. However the database table is not queried yet. There is about 25 columns in it.
Can I query this table from wonderware and return only the value that I require or do I have to return a full row to a bindlist. If I do have to create a bindlist, do I need to create 25 matching tags for the 25 columns in the table even though I dont need the extra 24 values.
I want to query a database and get one value from it.
I have the query I want working in microsoft sql server management. It is;
selecttop 1 [unknown value] from database where [known value] ='0002971465' orderby [DATE_TIME] desc
I have examples of how this database is connected to in wonderware. However the database table is not queried yet. There is about 25 columns in it.
Can I query this table from wonderware and return only the value that I require or do I have to return a full row to a bindlist. If I do have to create a bindlist, do I need to create 25 matching tags for the 25 columns in the table even though I dont need the extra 24 values.