![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213343.webp)
APPENDIX F – Obsolete Features
OMRON
Page 320
Release 2.0
chan = DDEInitiate(“SCS”, “Point”)
If chan <> 0 Then
‘Request “Array1” from CX-Supervisor and store in a row starting
at R1C1
Range(Cells(1,1), Cells(1,3)) = DDERequest(chan, “Array1”)
‘Request “Array2” from CX-Supervisor and store in a column
starting at R2C1
Range(Cells(2,1), Cells(4,1)) = DDERequest(chan, “Array2:col”)
‘Request elements [2] and [3] from “Array2” and store in R3C1 &
‘R3C2
‘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
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 when the point is created or modified.
Note:
All CX-Supervisor System points are given OLE2 read access by default.
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.
Summary of Contents for CX-SUPERVISOR - V2.0
Page 2: ...CX Supervisor User Manual Software Release 2 0...
Page 3: ......
Page 5: ...CX Supervisor User Manual OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor User Manual OMRON Page iv Revision 2 0...
Page 11: ...CX Supervisor User Manual OMRON Page viii Revision 2 0...
Page 13: ...CX Supervisor User Manual OMRON Page x Revision 2 0...
Page 15: ...CX Supervisor User Manual OMRON Page xii Revision 2 0...
Page 17: ...CX Supervisor User Manual OMRON Page xiv Revision 2 0...
Page 19: ...CX Supervisor User Manual OMRON Page xvi Revision 2 0...
Page 21: ...CX Supervisor User Manual OMRON Page xviii Revision 2 0...
Page 23: ......
Page 67: ......
Page 97: ......
Page 137: ...CHAPTER 7 Graphics Library OMRON Page 114 Release 2 0...
Page 183: ...CHAPTER 9 Animation OMRON Page 160 Release 2 0...
Page 215: ......
Page 263: ......
Page 269: ......
Page 274: ...OMRON CHAPTER 16 Connecting to Omron Industrial Components Release 2 0 Page 251...
Page 275: ......
Page 285: ......
Page 319: ......
Page 331: ......
Page 351: ......
Page 359: ...GLOSSARY OF TERMS CX Supervisor User Manual OMRON Page 336 Release 2 0...