Home » Developer & Programmer » Forms » OLE2 and DDE package books
OLE2 and DDE package books [message #206160] Wed, 29 November 2006 00:22 Go to next message
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!
Re: OLE2 and DDE package books [message #206170 is a reply to message #206160] Wed, 29 November 2006 00:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: OLE2 and DDE package books [message #206178 is a reply to message #206160] Wed, 29 November 2006 01:21 Go to previous messageGo to next message
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...
Re: OLE2 and DDE package books [message #206383 is a reply to message #206178] Wed, 29 November 2006 18:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: OLE2 and DDE package books [message #206392 is a reply to message #206383] Wed, 29 November 2006 19:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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.
Re: OLE2 and DDE package books [message #206626 is a reply to message #206622] Thu, 30 November 2006 20:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: OLE2 and DDE package books [message #206687 is a reply to message #206160] Fri, 01 December 2006 02:08 Go to previous messageGo to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried:
OLE2.SET_PROPERTY(cell, 'Value', '1234567890123456');
or
OLE2.SET_PROPERTY(cell, 'Value', '="1234567890123456"');

David
Re: OLE2 and DDE package books [message #207045 is a reply to message #206160] Mon, 04 December 2006 00:33 Go to previous messageGo to next message
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.
Re: OLE2 and DDE package books [message #207055 is a reply to message #207045] Mon, 04 December 2006 00:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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:
  


Current Time: Fri Dec 02 22:55:38 CST 2016

Total time taken to generate the page: 0.12121 seconds