OraFAQ Forum: Forms » OLE2 and DDE package books

Home » Developer & Programmer » Forms » OLE2 and DDE package books

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OLE2 and DDE package books [message #206160]

Wed, 29 November 2006 00:22

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Hi All,

I need to fully understand OLE2 and DDE package. Pressing F1 provides very limited help for me. Anyone here have or know some links of any reading materials(e-books, documentation)?
Please share... I'm drowned with my tasks here.

Thanks!

Report message to a moderator

Re: OLE2 and DDE package books [message #206170 is a reply to message #206160]

Wed, 29 November 2006 00:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

A search of this forum for 'ole dde' found http://www.orafaq.com/forum/m/87652/67467/?srch=ole+dde#msg_87652 which points to http://www.prestwood.com/community/paradox/info/dde_ole.html

Alternatively, search the Oracle Web site or google it.

David

Report message to a moderator

Re: OLE2 and DDE package books [message #206178 is a reply to message #206160]

Wed, 29 November 2006 01:21

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks David. That was not the OLE and DDE that we are using in oracle. I already spent 3 hours googling and still searching...

Report message to a moderator

Re: OLE2 and DDE package books [message #206383 is a reply to message #206178]

Wed, 29 November 2006 18:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://forums.oracle.com/forums/thread.jspa?threadID=169228&tstart=30 and http://www.gnome.org/projects/libgsf/gsf-MS-OLE2.html Do either of these meet your requirements?

You say "That was not the OLE and DDE that we are using in oracle." What OLE and DDE are you using?

David

Report message to a moderator

Re: OLE2 and DDE package books [message #206392 is a reply to message #206383]

Wed, 29 November 2006 19:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This is really quite depressing. I can NOT find anything of much use on OLE2 or DDE on Google or OTN. The only material I can find is through the help facility of the Forms builder!

There are numerous entries for OLE2 and DDE on metalink. The "WebUtil Sample Code and How To Reference Library " page on metalink , for the topic of "Using WebUtil to Provide / Replace OLE Integration e.g. MS Word, MS Excel" points to http://www.oracle.com/technology/products/forms/htdocs/webutil/howto_ole.html

David

[Updated on: Wed, 29 November 2006 19:24]

Report message to a moderator

Re: OLE2 and DDE package books [message #206622 is a reply to message #206160]

Thu, 30 November 2006 19:42

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Thanks David. Still that won't do.
I googled the web for a whole day but found nothing.
I think I have to study VB ole concept for this.

Report message to a moderator

Re: OLE2 and DDE package books [message #206626 is a reply to message #206622]

Thu, 30 November 2006 20:43

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What information do you think you need that wasn't supplied by the help facilty? Remember that when you select on the first option of DDE or OLE2 that you need to press the 'Previous' button to get to the main entry for the package (which isn't indexed in my version of the help system).

I also googled the web for little result. I strongly suggest searching metalink.

David

Report message to a moderator

Re: OLE2 and DDE package books [message #206687 is a reply to message #206160]

Fri, 01 December 2006 02:08

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Sorry David, I don't have that help facility of DDE or OLE. I'l try to search and download. Anyway if you have a good link please share.
For now, I just open excel then by pressing Alt+F11 and F2 I search for any cluea regarding this.
I found this on excel:

Worksheets("Sheet1").Range("A17").NumberFormat = "General"

..so I tried to use

OLE2.SET_PROPERTY(ExcelCellId, 'NumberFormat', 'Text' );

but doesn't work.
[edit]->> this is refering to my post regarding number.

[Updated on: Fri, 01 December 2006 02:10]

Report message to a moderator

Re: OLE2 and DDE package books [message #207028 is a reply to message #206687]

Sun, 03 December 2006 23:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you tried:

OLE2.SET_PROPERTY(cell, 'Value', '1234567890123456');
or
OLE2.SET_PROPERTY(cell, 'Value', '="1234567890123456"');

David

Report message to a moderator

Re: OLE2 and DDE package books [message #207045 is a reply to message #206160]

Mon, 04 December 2006 00:33

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

That won't do David. Well at last I found a solution to my problem regarding numbers. But still I want to learn OLE from the books, or should I say from the basics.

Report message to a moderator

Re: OLE2 and DDE package books [message #207055 is a reply to message #207045]

Mon, 04 December 2006 00:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

[What was the solution?] Sorry. You gave the solution in the other thread http://www.orafaq.com/forum/t/72811/67467/

David

[Updated on: Mon, 04 December 2006 00:50]

Report message to a moderator

Previous Topic:	commit problem
Next Topic:	Connect to Remote Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 17:12:15 CST 2025