The Hach WIMS Direct Server-Side Interface to Custom Q13429 Narrow Format SCADA is a replica of the Hach WIMS Direct Server-Side Interface to Narrow Format OLEDB Source (Q12160). The difference is two statistics have been added specifically for the client.

LASTRTP(-1) : Returns the last value of the previous time period.

LINTRTP(-1) : Returns the last value of the previous time period, and returns an integer value.

The reason for these two statistics is that there is a delay in when the values are transferred from the source data to an interim database. A -1 tells the interface how many slots to offset by. The query will look forward one time slot to the value for the current time slot.

For example, if we have a fifteen minute variable and we have 1.00 for 14:15 LAST value and 0.64 for 14:30 LAST value, then we would get the following results: