Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

SQLString

  • Last UpdatedNov 17, 2021
  • 1 minute read

The SQLString property is a read-write property that specifies the SQL statement to be executed by the Execute method.

Syntax

aaHistClientActiveDataGrid.SQLString = message;

Result = aaHistClientActiveDataGrid.SQLString;

Remarks

The aaHistClientActiveDataGrid uses the InSQL OLE DB provider to access the AVEVA Historian historical data. If you are querying data from the analog or discrete history tables, the SQL statement must follow the syntax rules for OLE DB provider queries. Otherwise, you can use any valid Transact-SQL that returns rows.

Remarks

The default is an empty message value ( "" ).

In This Topic
TitleResults for “How to create a CRG?”Also Available in