Subject RE: [IBO] Storing Office Documents in IB DBs; OT: Office Automation
Author Kaputnik

use OLE-documents with an OLE-container....
it is a simple matter of createOLEObject fromFile or so (don't remember
anymore, did it more than 6 months ago) and store it in the db as
after that, you can read the ole-object into a memorystream and open word
with this perfect for all office-docs and also for pdfs
and so...
if you like, I can send you some example-code privately, if I still have it
(don't know, though, changed the original source to use plain files instead
due to some problems with compression and encryption)....

CU, Kaputnik
(Nick Josipovic)

nick@... <mailto:nick@...>
kap@... <mailto:kap@...>
superior Client/Server programming: <>
a nice tool for Interbase: <>

> -----Original Message-----
> Hi,
> since December 2000, my company uses an application based
> on IB/IBO which the users (and me, too) are very satisfied
> with.
> For the next major version, I plan to implement a feature
> that enables the users to store word/excel docs in the
> DB.
> It should not just be
> - save to disk
> - store as blob in DB.
> It should be somehow like this:
> - user opens my app
> - clicks "create invoice" in my app
> - my app opens a new window with Microsoft Word in it
> - my app does some automation like inserting articles,
> prices, adress, etc.
> - when the user has finished, the doc is saved to the DB.
> Unfortunately, I have no idea how to do this.
> I have look around in the internet for a while and found
> some pointers, but I think there are some people here who
> have already done this and perhaps some of them could give
> some more valuable information :-)
> Generally, I would like to know:
> - how to call word etc. as a "child" of my application - some
> pointers to OLE or whatever
> - how to use IBO to save the results of the word session (= a document)
> in the database
> - some pointers to good howtos about office automation, hints, etc.
> I know that some of the above points do not really refer to IBO -
> so if some of your answers get too much OT feel free to e-mail me
> privately.
> One more information: I use Delphi4 C/S , IBO 3.6 and Office 2000.
> TIA for your answers.
> Christian