Post Select Data using DDE

You might have a tag naming convention which is not DDE compatible, or inappropriate for use in a DDE call. Plant SCADA provides the ability to publish specific tags under different names in DDE. This involves using the DDEpost function.

To make selected Plant SCADA variable values or the results of calculations available to external DDE Client applications currently running on the same computer, use the Cicode DDEPost() function to have Plant SCADA runtime behave as a DDE server.

This conversation is one-way, which allows an external DDE Client application (like Excel, Word, etc.) to read the value from Plant SCADA using DDE. The Client application cannot change this value in Plant SCADA.

You can use this function to present data under a different name than its source. For instance, the following example presents the value of variable tag PV1 as "Process1".

The following Cicode example posts the value of variable PV1 using DDE:

DDEPost("Process1", PV1)

Once posted, this value can be accessed, for example, from a cell in Excel containing the following formula:

=Citect|Data!Process1

or from a field in Microsoft Word containing the following function:

{DDEAuto Citect Data Process1 }

Notes:

• The name of the posted value (for example Process1) not to exceed 8 characters or contain spaces if you want to link to it via a Microsoft Word DDE field. Microsoft Excel, however, accepts long data item names if enclosed within single quotes (for example 'Process Variable 1').

• You need to use Data as the DDE Topic name when accessing posted values. See Set up DDE Conversations.

This method of DDE connection requires that both Plant SCADA runtime and the DDE Client application (for example Excel or Word) are running on the same computer at the same time. Once the DDE connection has been made, the DDE Client would normally display the updated value of the Plant SCADA DDE posting as soon as it becomes available, usually within milliseconds of the post.

Unfortunately, this posting method of DDE linking is subject to breakage whenever Plant SCADA runtime is closed, even if Plant SCADA runtime is subsequently restarted. The DDE Client application might not detect the lack of connection, as updates to the data in the DDE Client (for example Excel) only occur after each post by the DDE server (Plant SCADA runtime). If no further posts occur, and in this scenario none will (as the DDE link is disconnected), the DDE Client application receives no update, and subsequently might display data which could be out of date. This disconnected state will remain until the DDE link in the DDE Client application is refreshed or the DDE Client application is restarted.

See Also

Write Values to a DDE Application