Kbase 13738: DDE-NOTIFY FIRES FOR ALL LINKS ( EXCEL DDE ADVISE )
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
DDE-NOTIFY FIRES FOR ALL LINKS ( EXCEL DDE ADVISE )
The following problem occurs when using DDE and EXCEL. The behavior
is caused by the way EXCEL handles the NOTIFY event and cannot be
modified by PROGRESS.
If you initiate a DDE conversation with EXCEL
and have multiple links (DDE ADVISE) to different EXCEL cells,
you can't identify which data cell changed when the DDE NOTIFY event
goes off.
In other words the following code will display BOTH messages:
ON DDE-NOTIFY OF FRAME x DO:
IF FRAME x:DDE-ITEM = "r10c2" THEN MESSAGE "Hello".
ELSE IF FRAME x:DDE-ITEM = "r10c3" THEN MESSAGE "Goodbye".
END.
Workarounds: 1) On the dde-notify event, check each item to see if the
data has changed or not to determine which one it is.
OR
2) set up a different frame for each data cell link you want to have.
Progress Software Technical Support Note # 13738