Applies To:
  • CitectSCADA 5.21, 5.21 Service Pack C
Summary:
Using the CTAPI ctFindFirst function you can access the RDB databases of Citect. However the RDB files contain very low level binary information which is not useful to customers. 

Solution:
To provide more useful information CTAPI has been enhanced in version 5.21 SP C to support views of the RDB databases. These views remove the unnecessary internal binary information and convert some binary information into a useful string format. To access the views you use the ctFindFirst() function passing the name of the view. You may still access the original RDB data by specifying the raw RDB table name. The following views are supported:

NAME PROPERTIES

===== ==========

Tag "{TAG,64}{RAW_ZERO,10}{RAW_FULL,10}{ENG_ZERO,10}{ENG_FULL,10}{ENG_UNITS,8}{COMMENT,64}"

Trend "{TAG,64}{RAW_ZERO,10}{RAW_FULL,10}{ENG_ZERO,10}{ENG_FULL,10}{ENG_UNITS,8}{COMMENT,64}{SAMPLEPER,16}{TYPE,8}"

Accum "{NAME,64}{TRIGGER,1}{VALUE,16}{RUNNING,16}{STARTS,16}{TOTALISER,16}{AREA,6}

DigAlm "{TAG,16}{NAME,32}{DESC,80}{HELP,16}{CATEGORY,8}{STATE,16}{TIME,12}{DATE,12}{AREA,6}"

AnaAlm "{TAG,16}{NAME,32}{DESC,80}{HELP,16}{CATEGORY,8}{STATE,16}{TIME,12}{DATE,12}{AREA,6}"

"{VALUE,16}{HIGH,12}{LOW,12}{HIGHHIGH,12}{LOWLOW,12}{DEADBAND,12}{RATE,12}{DEVIATION,12}"

AdvAlm "{TAG,16}{NAME,32}{DESC,80}{HELP,16}{CATEGORY,8}{STATE,16}{TIME,12}{DATE,12}{AREA,6}"

To get any real time data from the view the CTAPI connection should be talking with the required server. For example if you want valid information in the STATE property of the DigAlm view CTAPI should be connected to the alarm server. You can get static configuration properties from any Citect, for example the TAG and TREND view provide only static configuration data.

 
Keywords:
 

Attachments