Querying CDBPoint for a Single Data Type

[Anonymous user]

📖 Home  Back  
All points are recorded in the database table CDBPoint. On of the base classes (CDBObject) contains a field named TypeDesc. This string holds a text description of the class (or type) of the object.

For an internal analog point, the TypeDesc will be "Internal Analog Point" or "Internal Analogue Point".

For a DNP3 Analog Input Point, the TypeDesc will be "DNP3 Analog Input Point" or "DNP3 Analogue Input Point"

Note text description for TypeDesc may be determined by the locale of the currently logged in user. For example, the English (US) locale uses Analog whereas English (UK) locale uses Analogue.

To retrieve a list of all analog points, you could format a query as follows:

SELECT * FROM CDBPoint WHERE TypeDesc LIKE '%Analog%Point%'

Note the format of the search string after the LIKE keyword. The % sign indicates that multiple characters can be inserted here. The % between Analog and Point allows for words such as Input and Output while still returning the list of points required.

A similar approach could be adopted to retrieve a list of digital points, remembering that digitals can be referred to either as a digital or binary. An example query for digital points could be as follows:

SELECT * FROM CDBPoint WHERE (TypeDesc LIKE '%Digital%Point%') OR (TypeDesc LIKE '%Binary%Point%')

Note that there are other types of objects in the database that will store point values but have no been considered analog point values for the purposes of this example.  This will depend on the drivers which you have installed on your system.

Go: Home Back