DDE TERMINATE statement

This statement is supported only for backward compatibility. Use the Component Object Model (COM) instead.


DDE TERMINATE `ddeid` [ NO-ERROR ]

An integer expression that equals the channel number of an open conversation. It is the value returned by the DDE INITIATE statement that opened the conversation.

By default, if the statement fails to close the conversation, the AVM raises the ERROR condition, and posts the error to the DDE frame DDE-ERROR attribute. If you specify NO-ERROR, the AVM does not raise the ERROR condition but does post the error to the DDE frame.

The following fragment shows a typical use of the DDE TERMINATE statement. It assumes that the Microsoft Excel application is running, and has created the default Excel worksheet, Sheet1. It then uses the DDE INITIATE statement to open a conversation with Sheet1 as the topic, returning the channel number of the conversation to the variable, Sheet1. After exchanging data with the worksheet, the example closes the conversation with Sheet1 using the DDE TERMINATE statement.

DEFINE VARIABLE Sheet1 AS INTEGER NO-UNDO. /* DDE-ID to worksheet topic / DEFINE VARIABLE DDEframe AS HANDLE NO-UNDO. / DDE frame handle / CREATE FRAME DDEframe. / Create DDE frame / . . . / Open a DDE conversation with "Sheet1" and assign column headings. / DDE INITIATE Sheet1 FRAME DDEframe APPLICATION "Excel" TOPIC "Sheet1". DDE SEND Sheet1 SOURCE "Name" ITEM "R1C1". DDE SEND Sheet1 SOURCE "YTD Sales" ITEM "R1C2". DDE SEND Sheet1 SOURCE "State" ITEM "R1C3". . . . DDE TERMINATE Sheet1.*

DEFINE VARIABLE Sheet1   AS INTEGER NO-UNDO. /* DDE-ID to worksheet topic */ 
DEFINE VARIABLE DDEframe AS HANDLE  NO-UNDO. /* DDE frame handle */ 
CREATE FRAME DDEframe.                       /* Create DDE frame */ 
. . . 
/* Open a DDE conversation with "Sheet1" and assign column headings. */ 
DDE INITIATE Sheet1 FRAME DDEframe APPLICATION "Excel" TOPIC "Sheet1". 
DDE SEND Sheet1 SOURCE "Name"      ITEM "R1C1". 
DDE SEND Sheet1 SOURCE "YTD Sales" ITEM "R1C2". 
DDE SEND Sheet1 SOURCE "State"     ITEM "R1C3". 
. . . 
DDE TERMINATE Sheet1.

Before closing a DDE conversation, remove all advise links in the conversation using the DDE ADVISE statement.

Closing this conversation makes ddeid unavailable for further exchanges, but any other conversations open to the same server are still available.

For more information on using the DDE protocol to exchange data with non-ABL applications, see OpenEdge Development: Programming Interfaces.

DDE TERMINATE statement

(Windows only)