TN HistClient124 How to run a sql query in the Historian Client ActiveData Grid using a script

1. Double click the ActiveDataGrid

2. Type in the name in the ControlName field, e.g., aaHistClientActiveDataGrid1

Set the query using the .SQLString dot field

#aaHistClientActiveDataGrid1.SQLString = "

USE RUNTIME

SELECT Datetime, Tagname, Value, QualityDetail 
FROM Live 
WHERE Tagname = 'SysTimeSec'" ;

#aaHistClientActiveDataGrid1.Execute();

***You can also use concatenation and use Message tags to fill the query***

#aaHistClientActiveDataGrid1.SQLString = "USE RUNTIME
SELECT Datetime, Tagname, Value, QualityDetail
FROM " + StringTag2 + "
WHERE Tagname = '" + StringTag1 + "'" ;