Re: Using OLE in Forms 5.0 to call Word 97
From: Sequel Solutions <info_at_sequel.nl>
Date: Sun, 6 Feb 2000 21:00:17 +0100
Message-ID: <87kk5m$2g7$2_at_news1.xs4all.nl>
>in order to print and/or view documents on the filesystem.
>
>Preferably it should also be able to use Word to print not only DOC
>files, but also other files which can be handled by Word, such as RTF
>and HTML. The actual filenames will be known only at runtime, whether
>by fetching from the database or accepting user input (thus no
>predefined OLE/OCX links or embedding at design time).
>
>Unfortunately the available documentation on using OLE in Forms is very
>scarce. All I have now are the few pages available in the Forms
>Advanced Techniques manual and a document from technet.oracle.com titled
>"WIN: OLE AUTOMATION GUIDE-ORACLE FORMS TO MICROSOFT WORD" which
>describes some operations using WordBasic via the OLE2 package. And
>I can barely find anything on using the procedures and packages created
>by the OLE importer.
>
>Can any of you please give an example of how to print a document via
>Word based on a filename (without necessarily opening Word in a visible
>manner), or of invoking Word to open a file for viewing? Or ANY working
>example of using procedures from the OLE importer to call ANYTHING with
>Word or Excel? Or could you point me to some more thorough
>documentation (web sites or books) on using OLE in Forms?
>
>
>Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy. Received on Sun Feb 06 2000 - 21:00:17 CET
Date: Sun, 6 Feb 2000 21:00:17 +0100
Message-ID: <87kk5m$2g7$2_at_news1.xs4all.nl>
You are looking for integration Oracle data within Microsoft Word. You can use Ole2, but it's rather slow.
We have developed SQLWord that might be interesting for you:
SQLWord
Advanced Reportwriter integrating Oracle and Microsoft Word. You can create your own standardletters, contracts and any other reports using the data of an Oracle database within a Microsoft Word document. By placing the fieldnames (keywords) of the queries in the text of the document, SQLWord retrieves the necessary data from the Oracle database and integrates it in the generated output document. Nested structures can be used unlimited (master-detail-detail etc).
Please have a look at our website at http://www.sequel.nl
Sincerely,
Sequel Solutions
<drobinson1_at_my-deja.com>
wrote in message news:87c7iu$es8$1_at_nnrp1.deja.com...
>I
have a basic requirement which involves using Forms 5 to call MS Word>in order to print and/or view documents on the filesystem.
>
>Preferably it should also be able to use Word to print not only DOC
>files, but also other files which can be handled by Word, such as RTF
>and HTML. The actual filenames will be known only at runtime, whether
>by fetching from the database or accepting user input (thus no
>predefined OLE/OCX links or embedding at design time).
>
>Unfortunately the available documentation on using OLE in Forms is very
>scarce. All I have now are the few pages available in the Forms
>Advanced Techniques manual and a document from technet.oracle.com titled
>"WIN: OLE AUTOMATION GUIDE-ORACLE FORMS TO MICROSOFT WORD" which
>describes some operations using WordBasic via the OLE2 package. And
>I can barely find anything on using the procedures and packages created
>by the OLE importer.
>
>Can any of you please give an example of how to print a document via
>Word based on a filename (without necessarily opening Word in a visible
>manner), or of invoking Word to open a file for viewing? Or ANY working
>example of using procedures from the OLE importer to call ANYTHING with
>Word or Excel? Or could you point me to some more thorough
>documentation (web sites or books) on using OLE in Forms?
>
>
>Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy. Received on Sun Feb 06 2000 - 21:00:17 CET