Security Command R500 Spécifications télécharger pdf (Page 444)

100

101

20 – Using PlantScape Data in Other Applications

426 R400

Notes

All SQL keywords may be abbreviated to the first 2 letters

Each line must be no more than 80 characters long

Data can only be uploaded to the PV of a point if the option “Enable PV

Data Upload” is enabled.

Data can only be uploaded to the history parameters of a point if the option

“Enable History Data Upload” is enabled.

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

24 hour extended history

Parameter Description

plscpcg.book Page 426 Monday, May 28, 2001 10:11 AM

1 2 ... 439 440 441 442 443 444 445 446 447 448 449 ... 583 584

Commentaires sur ces manuels

Pas de commentaire

Security Command R500 Spécifications Page 444

Commentaires sur ces manuels

Produits connexes et manuels pour Systèmes de contrôle d'accès de sécurité Security Command R500