Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DDE command problems

646 views
Skip to first unread message

Jennifer Vuong

unread,
Mar 3, 1997, 3:00:00 AM3/3/97
to

I'm trying to use the DDE commands
1) 'DDE.REQUEST' to request some data from MS-EXCEL v5 to ORACLE FORMS v4.5. I've tried to use
the commands below

convid := DDE.Initiate('EXCEL','C:\test.xls');
DDE.REQUEST(convid,'R2C2:R3C4',buffer,DDE.CF_TEXT,1000);

DDE.REQUEST commands failed with an error "DDE.DMLERR_NOTPROCESSED" ie.transaction failed. The
item name in a POKE or REQUEST transaction may be in error.
The above DDE.REQUEST command that I'm using is exactly the command that was use as an example
in the "ORACLE DEVELOPER/2000". So, is there a typo in the manual or did I miss out something ?

2) I've exactly the same error as above when I tried to use the 'DDE.POKE' command

DDE.POKE(convid,'R2C2','XXX',DDE.CF_TEXT,1000);


Can anyone help?

Thanks

Lang Richard

unread,
Mar 10, 1997, 3:00:00 AM3/10/97
to

1.) Be sure that Excel is open for DDE-comunications:
Begin
Canal := DDE.INITIATE('EXCEL', 'System');
exception when DDE.DMLERR_NO_CONV_ESTABLISHED
then
Appl := DDE.APP_BEGIN('C:\EXCEL\EXCEL.EXE', DDE.APP_MODE_NORMAL);
Canal := DDE.INITIATE('EXCEL', 'System');
END;
2.) Open the file and then a canal on this sheet, for direct get/set
with
POKE/REQUEST. (Only possible with a canal on the sheet)

DDE.EXECUTE(Canal, '[open "c:\test.xls"]', 5000);

DDE.TERMINATE(Canal);
Canal := DDE.INITIATE('EXCEL', 'c:\test.xls');

3.) Make your POKE and REQUEST beeing attention on Syntax an installed
language of Excel. R/C= English Z/S German...
You can also reference named-fields in your sheet:
Example B3 you called IN_VALUE and B5 OUT_VALUE.
Now you can make this:
DDE.POKE(Canal, 'IN_VALUE', '10', DDE.CF_TEXT, 5000);
DDE.REQUEST(Canal, 'OUT_VALUE', Buffer, DDE.CF_TEXT, 5000);

Remember: You can only reference field's in the actual open sheet,
otherwise
you have to change sheet.
You can only use ExcelMakro4-Command.
It is better to you use OLE (more secure)
For both DDE and OLE you can find examples in the WINDEMO.pll

------------------------------------------------------------
Lang Richard EMAIL: Richar...@dse.it
DSE or : ric...@calico.dse.it
39100 Bozen
Buozzi 8 Tel.: 0039 471 555 711
(BZ) ITALY

Privat:---> Lang Richard
================ 39019 Dorf Tirol
Ruprechtweg. 4
Tel.: +39 473 565 149
(BZ) ITALY
------------------------------------------------------------

0 new messages