SQLQueryTableTPPs

Used by the ODBC Server option to group data records by time interval. By adding the application property, SQLQueryTableTPPs, you can retrieve tag data from specific time intervals. The format of the statement is:

SQLQueryTableTPPs = <time frame specifier>

where the time frame specifier takes the form of a digit and a letter. The letter indicates the units in which time interval is measured (hours: H , weeks: W, etc.) and the digit specifies the number of units of each interval that should pass between each record.

The available time interval units are:

MS - milliseconds

S - seconds (this is the default, therefore the S may be omitted)

M - minutes

H - hours

D - days

W - weeks

Y - years

Default: SQLQueryTableTPPs=

Section: System