Specifications

20 – Using PlantScape Data in Other Applications
426 R400
Notes
1 All SQL keywords may be abbreviated to the first 2 letters
2 Each line must be no more than 80 characters long
3 Data can only be uploaded to the PV of a point if the option “Enable PV
Data Upload” is enabled.
4 Data can only be uploaded to the history parameters of a point if the option
“Enable History Data Upload” is enabled.
5 If you include the keyword NUMERIC, the PV is transferred as a numeric
value.
Example The following example will extract the PV of the SQLSINE point on the server so
that it can be stored in the ODBC-compliant database.
update rwb
set realnum=("@ POINTREF POINTNAME sqlsine PARAMETER PV @")
where name_id=‘Fred Smith’;
The following example will extract a value from the SQL database, and store it in
the PV of the SQLSINE point on the local PlantScape server.
select small from rwb where name_id=‘Fred Smith’;
“@ POINTREF POINTNAME sqlpnt PARAMETER PV @"
H24HE
4
24 hour extended history
Parameter Description
plscpcg.book Page 426 Monday, May 28, 2001 10:11 AM