Product specifications

Accessing 800xA via OLE DB
470 3BDS011222-510 B
Keywords
A description of the keywords and their respective meaning and syntax can be seen
in the table below:.
Table 26. Keywords
Keyword Description
OBJECT The full path or the GUID
(1)
of the object.
ASPECT The name or GUID of the aspect where the property belongs.
OBJECTHEL
PER
The name of the short references that holds the OleDB Tables, DA
or HDA, i.e. the help aspects.
PROPERTY The name of the property.
LOG The name of the log.
ITEMID A string built up according to HDA standard which looks like this:
{OBJECT GUID}{ASPECT GUID}:PROPERTY,LOG
When you use Data Access you will get a shorter ItemId string in
return and it looks like this:
{OBJECT GUID}{ASPECT GUID}:PROPERTY,
FROM The time to start gathering data. The time is specified using
OPCHDA_TIME (se time definition in section 1.3.3)
Example: FROM=WEEK+7h30m (Monday morning at 7:30)
TO The time to stop gathering data. The time is specified using
OPCHDA_TIME.
Example: TO=NOW (the time that the command is executed)
Aggregate Calculation method on the processed data:
None, Interpolated, Total, Average, TimeAverage, Count, Stdev,
MinimumActualTime, Minimum, MaximumActualTime, Maximum,
Start, End, Delta, Regslope, Regconst, Regdev, Variance, Range,
DurationGood, DurationBad, PercentGood, PercentBad,
WorstQuality, Annotations
Observe that the OPC server may not support all methods.
Example: Aggregate=Average (time average over the period)