Specifications

20 – Using PlantScape Data in Other Applications
428 R400
Parameter
Any valid parameter name, including control module point parameters
can be used.
For a complete list of point parameters see Table 8.1, “Summary of
Point Parameter Types,” on page 134.
Notes
• All SQL keywords may be abbreviated to the first 2 letters.
• Specify either the date and time, or an offset, but not both.
Example The following example will extract five SQLSINE values in 6 minute history
starting from 10 samples ago, and store values in the ODBC-compliant database.
insert into historytable
values
(“@HISTORYREF POINTNAME sinewave TYPE H5SF OFFSET 5
ITEMS 10 @”)
;
plscpcg.book Page 428 Monday, May 28, 2001 10:11 AM