DDE TERMINATE statement

(Windows only)

Closes the specified dynamic data exchange (DDE) conversation.

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

Note: Does not apply to SpeedScript programming.

Syntax

DDE TERMINATE ddeid [ NO-ERROR ]
ddeid
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.
NO-ERROR
The NO-ERROR option is used to prevent the statement from raising ERROR and displaying error messages.

Regardless of whether NO-ERROR is used, the AVM posts the error to the DDE frame DDE-ERROR attribute.

Example

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.

Notes

See also

DDE ADVISE statement, DDE INITIATE statement, NO-ERROR option