OLE Automation Appendix F Obsolete Features
317
'The '[ ]' or '.' format can be used to delimit
the array index
Cells(3,1) = DDERequest(chan, "Array2[2]")
Cells(3,2) = DDERequest(chan, "Array2.3")
End If
End Sub
F.5 OLE Automation
OLE Automation provides a mechanism whereby one application can control
another. In order to access a CX-Supervisor points value via OLE Automation,
it must be given either OLE Read or OLE Write access. This can be achieved
by checking the appropriate box in the Advanced Point Settings dialog box
when the point is created or modified.
CX-Supervisor exposes the following Runtime functions via OLE2 Automation:
• SetValue(stringPointName,Value). Enables any point with OLE Read/
Write access to be modified (value may be Boolean, integer, long or
string).
• GetValue(stringPointName,&Value). Enables any point with OLE Read
access to be monitored (value may be Boolean, integer, long or string).
• QueryCount(). Returns the total number of points in the CX-Supervisor
database.
• QueryId(stringPointName), Returns the WORD id of a given point name.
The id is an integer in the range between 1 and the total number of points
in the CX-Supervisor database.
• QueryOLE(wordID). Returns the Read/Write access rights of a point as an
integer. 0 represents no access type; 1 represents Read Only; 2
represents Read/Write; 3 represents an invalid access type.
• QueryType(wordID). Returns the points data type as an integer from a
given id. 0 represents a void datatype; 1 represents a digital datatype; 2
represents an integer datatype; 3 represents a real datatype; 4 represents
a text datatype; 5 represents an invalid datatype.
• QueryName(wordID). Returns the points name string from a given
identity. CX-Supervisor provides OLE Automation helper routines and
code examples in the OLE2AUTO subdirectory. Refer to the file
OLE2AUTO.WRI in that subdirectory for more information.
F.6 OLE Overview
The Microsoft Windows operating environment allows the transfer and sharing
of information between applications by using a technique known as Object
Linking & Embedding, or OLE (pronounced olé). Embedding allows drawings,
sounds or almost any objects to be created within an application, and then
inserted (embedded or linked) within another file or document. The embedded
object can then be edited (or activated) by merely double clicking on it. Linking
allows an object to be shared by several documents by forging links between
the destination documents and the source object, e.g. a company logo may
appear in several word processor documents by linking to a graphics object
rather than embedding.
Embedding and Linking Objects within the CX-Supervisor application can
either be achieved by using the Object Packager, or by embedding or linking
objects directly within a page.
Note: All CX-Supervisor System points are given OLE2 read access by default.